Show Blank is cell value=0 but count as a zero in sum. How to format this cell ?

[Markus Obermayer]

I some Excel 2003 cells in a columns I have occasionally a value of 0.0 (=zero).
I want to format these cells to display blank (not "0.0") if the value is 0.
But in the columns sum line ("=SUM(C4:C14)") this cell should be treated as a value of 0.

How do I format this cell in Excel 2003?

Markus

[Peo Sjoblom]

One way

0.0;0.0;

Regards,

Peo Sjoblom

"Markus Obermayer" wrote:

> I some Excel 2003 cells in a columns I have occasionally a value of 0.0 (=zero).
> I want to format these cells to display blank (not "0.0") if the value is 0.
> But in the columns sum line ("=SUM(C4:C14)") this cell should be treated as a value of 0.
>
> How do I format this cell in Excel 2003?
>
> Markus
>
>

[swatsp0p]

You can also choose to "hide" zero values from the Tools | Options>View tab, uncheck Zero Values. These cells are calculated as zeros, just not shown on screen.

Also, I'm not sure I understand the impact of a zero value in your Sum line? However, if doing Count, Average, Stdev, etc. the blank cells are calculated.

HTH