K
Kathleen Koch
This is quoted directly from the Excel user's manual.
I've recently used it and it works exactly as you are
asking it to.
"Use a number format to hide zero values in selected cells
Caution This topic applies a format 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 zeros (0's) 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;;@"
I've recently used it and it works exactly as you are
asking it to.
"Use a number format to hide zero values in selected cells
Caution This topic applies a format 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 zeros (0's) 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;;@"