Trap it with and IF, eg use instead in A5:
=IF(SUM(A1:A4)=0,"",SUM(A1:A4))

Alternatively, perhaps better,
we can easily suppress the display of zeros in the sheet via clicking:
Tools Options View tab Uncheck "Zero values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Turk" wrote:
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