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.