I don't think you can directly hide zero values only in selected rows.

You can change formulas to result in "" if the result =0, but this can cause
other problems.

The easiest way would be to use an accounting number format, 0 shows as -.
While is is not totally hidden, it is better than a bunch of 0's.

If you dont like the "-", customize the number format to use " " instead
_(* #,##0.00_);_(* (#,##0.00);_(* " "??_);_(@_) is the accounting format
with - removed. The (* " "??_) section used to be (* "-"??_)


--
If this helps, please remember to click yes.


"Steve J" wrote:

Hi all,

I know how to hide all zero values in 2003, but the problem is only want
to hide zero values of selected rows. Is there anyway to do this?
.