Hidding zero values

S

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?
 
S

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
Click to expand...

--
Simon Lloy

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

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?
Click to expand...

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.
 
P

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

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.
Click to expand...

Tried both and work great! thx guys
 
Top