Hidding zero values
 

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?

Hidding zero values
 

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

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

Steve J;579642 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?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160285

Microsoft Office Help

Hidding zero values
 

On 7 dec, 15:45, 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?

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.

Hidding zero values
 

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

Hidding zero values
 

RadarEye wrote in news:573e1ff3-2559-4ceb-88c1-
:

On 7 dec, 15:45, Steve J wrote:
Hi all,

I know how to hide all zero values in 2003, but the problem is *only
wa
nt
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.


Tried both and work great! thx guys

Hidding zero values
 

You might also try conditional formatting - set the font color to the cell
background color if that cell's value is zero.

HTH,

Eric


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