Excel Custom Cell Formatting To Display Blank Instead Of Zeros

There are Excel built-in options to set how zeros are displayed in the spread sheet. However, there are times when only certain cells need the special exceptional treatment then a little more work is involved with customer cell formatting.

If you want to hide specific zero values, but not all, you can use a numeric format instead:

1.Select the cells that contain the zero values that you want to hide.
2.Click the Home tab and click the Number group’s dialog launcher (the small arrow in the bottom-right corner. In Excel 2003, choose Cells from the Format menu.
3.Click the Number tab (if necessary).
4.Choose Custom from the Category list.
5.Enter 0;-0;;@ in the Type field.
6.Click OK.

[TechRepublic] Three ways to hide zero values in an Excel sheet