Thread: Show Blank is cell value=0 but count as a zero in sum. How to format this cell ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Markus Obermayer Markus Obermayer is offline
external usenet poster
  
Posts: 8
Default 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

Reply With QuoteReply With Quote