PS. It needs to be a number and not text as other formulas use that value of
0. So '0 will not do it for me.

Rob

"Rob" wrote in message
...
Hi,

I have set the option to not show Zero values on a worksheet, but there is
one cell that I do want to see as 0.

That cell is not a formula, just a 0. Is there a way to do this, maybe
through a custom format?

Rob