View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MIchel Khennafi MIchel Khennafi is offline
external usenet poster
 
Posts: 9
Default How to hide "0" in a cell?

Download ASAP utilities from the ASAP web site... It is a free addin
"Turk" wrote in message
...
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