Format = Format cells = Number = Custom
Now input a new custom format: #;#;;

Joerg

"S S" wrote in message
o.uk...
Formula =SUM(E10:E20)
If there are no amounts in this column then the total displays 0
Is there a way to display the total cell as blank so that the 0 does not
appear.

thanks

--