Hidding zero values

[Steve J]

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?

 

[Simon Lloyd]

You would probably be best using formula =IF(A1=0,"",A1

A simplistic view of the formula but thats it, or you can create
custom view if they are always the same cells at the same time

Hi all

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

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[RadarEye]

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?

Hi Steve,

Try your luck with conditional format.
As conditoon use value= zero
As format make the font color the same as the interiour color.

HTH,

Radareye.

 

[Paul C]

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 (* "-"??_)

 

[Steve J]

wa

Hi Steve,

Try your luck with conditional format.
As conditoon use value= zero
As format make the font color the same as the interiour color.

HTH,

Radareye.

Tried both and work great! thx guys