Select the cell, and choose FormatCells
On the Number tab, choose Custom
In the format box, type:
#,##0;-#,##0;"0"
Click OK


Rob wrote:
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






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html