What is the simplest way

[famdamly]

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

[jhct]

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.

[Arvi Laanemets]

Hi

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


Arvi Laanemets


"famdamly" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[[email protected]]

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

[George]

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