You're welcome, and I see that Nick has answered the formatting question.

Rob wrote:
Thanks Debra,

That did the trick!!......and experimenting with that, so does ;;"0"
(although I don't know why).

Rob

"Debra Dalgleish" wrote in message
...

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






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