Thread: Okay, want to learn this once and for all, how _do_ we get rid of zeros formulaically?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GTVT06 GTVT06 is offline
external usenet poster
  
Posts: 141
Default Okay, want to learn this once and for all, how _do_ we get rid ofzeros formulaically?
Hello,
Can you reformat the cell? Format Cells/Custom/ and formatting it as #
should clear it, or you can do =if(SUM('2007-2009'!
L22:O22)=0,"",SUM('2007-2009'!L22:O22))

Reply With QuoteReply With Quote