Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying a blank cell | Excel Discussion (Misc queries) | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) |