Follow this procedure to hide zero values in selected cells. If the value in one of these cells changes to a nonzero value, the format of the value will be similar to the general number format.

Select the cells that contain the zero (0) values that you want to hide.

On the Format menu, click Cells, and then click the Number tab.

In the Category list, click Custom.

In the Type box, type 0;-0;;@