Posted to microsoft.public.excel.misc
|
|
Hide Zero values bar one
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
|