Rob

Testing it, can you put something like


0.00000000000001 in a cell and format as number with no decimals, that way
it would not get picked up by un-checking zero values and providing you make
sure you use ROUND functions for anything based on it, you should be ok to
use it in calculations

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Nick Hodge" wrote in message
...
Rob

I don't wish to sound facetious, but you've elected to hide all zeros!
You have identified the only way in converting it to text.

Could you reset to show zeros and use conditional formatting of white text
when a cell value is zero, and then leave your one without it?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Rob" wrote in message
...
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