What is the simplest way
 

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

What is the simplest way
 

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

What is the simplest way
 

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

What is the simplest way
 

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

What is the simplest way
 

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