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

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

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.

Tried both and work great! thx guys
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top