Show Zero Value in Cell

[r_know]

hello there,

I disable the "Show a Zero in a cell that have Zero value" reasons I have so many links.
But, if I apply 0 value manually or 00:00 which is not shown in cell.

What should do if I want to see 0 (as number) & 00:00 as (hh:mm) when I apply in Cell even disable in setting option-advance-?

Reg, RL

[p45cal]

How about if you left zeroes showing, but on those cells where you don't want to see a zero apply a conditional format to show the font as white (actually the same colour as the cell's background, should that not be white) when that cell's value is zero?

[r_know]

It will be big process to make changes as per conditioning format!
Any other ways?

[p45cal]

you could use a macro, either on sheet recalculate or sheet change event, which could check each cell in the used range of the sheet and adjust the font colour accordingly - is that a route you'd be happy to go down?