Thread: How to hide "0" in a cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Turk Turk is offline
external usenet poster
  
Posts: 11
Default How to hide "0" in a cell?
Dear all,

I have a formula "=sum(a1:a4)" at cell a5, normally it will display a "0"
when cells a1 to a4 are all blank. How can I hide this "0"?

Thanks


Turk


Reply With QuoteReply With Quote