1. Hide zero Values. Hide all of the zero values in a worksheet by adjusting Excel’s options as follows: Instead of a zero it will show a blank cell.

a. In Excel, select File, Options, Advanced. Under the Display options for this worksheet section, uncheck the box labeled Show a zero in cells that have a zero value and click ok.

Will Change to the following:

2. Display zero values as a dash. You can display zero values in your worksheet as a dash by changing the cell’s format to either the Accounting or Comma Style format. On Tools bar click on the arrow and select type of format:

a. Accounting will change as follows:

Go from this to Dashes & Dollar signs using Accounting Format:

Or Comma Style will show as dash for zero and no $.

Comma Style: