Formatting The Appearance of Zero Values

Select the cell you want to modify.
On the Home tab, click Cell, and then click Numeric.
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 (- -)