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.

1. 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.

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:

Accounting will change as follows: Comma Style