Formatting The Appearance of Zero Values
-
Select the cell you want to modify.
- In the Display Zero as list, select the way you want zero values to appear when printed.
-
Click OK.
To print zero values as a |
Choose |
- |
Dash (-) |
0 |
Zero (and then specify number of decimals) |
NIL |
NIL |
|
Blank |
N/A |
N/A |
nil |
Nil |
- - |
Dashes (- -) |