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

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

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

Tools=Options=View, then unselect Zero Values - this will suppress zeros
on the whole sheet however.


a custom number format done on a cell by cell basis would be

positive,negative,zero,text

so use your positive and negative only

an example:
#,##0_);(#,##0);

include the last semi-colon.

--
Regards,
Tom Ogilvy


"Markus Obermayer" wrote in message
...
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.

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

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