| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show or blank out a cell dependant on an selection in another cell | Excel Discussion (Misc queries) | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| How to get a cell with a zero errorto show the cell as blank | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Threaded Mode
