to have a cell that has a value of zero just be blank instead of showing
the 0


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=513079

Hi

=IF(YourFormula=0,"",YourFormula)


Arvi Laanemets


"famdamly" wrote in
message ...

to have a cell that has a value of zero just be blank instead of showing
the 0


--
famdamly
------------------------------------------------------------------------
famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=513079

probably not the quickest way...but if my sheet has no background colour
(i.e - its white), I just apply a conditional format to colour the font
white if its equal to zero, then paint the format wherever you want it.
Does the trick for me.


--
jhct
------------------------------------------------------------------------
jhct's Profile: http://www.excelforum.com/member.php...o&userid=31562
View this thread: http://www.excelforum.com/showthread...hreadid=513079

Try the following in order to make all zeros show blank.

Click on Tools - Options
Select the View tab
Deselect the Zero values option
Click on OK

Change the cells number format
Format Cells Number
Then select custom

It has 4 sections separated by semi-colon
Positive;negative;zero;text
so for eg.
"0.00";[RED]-"0.00";""
Positives: 2 decimal places
Negatives: 2 decimal places in red
Zero : is blank

Although i prefer to use the dash
"0.00";[RED]-"0.00";"-"
The dash is less intrusive but still lets you know the cell has a value
and is not blank

George


famdamly wrote:
to have a cell that has a value of zero just be blank instead of showing
the 0