something like:
=If(Yourformula=0,"",Yourformula)
Note that there is NO space between the two quote marks. In other words, it
is "", not " ". HTH Otto
"Steved" wrote in message
...
Hello from Steved

With the below formula what is required please to have the cell blank as
at
the moment it shows 0.

ps I do not want to turn zero off

='City Depot'!C9+'Panmure Depot'!C9

Thankyou.