How to force individual cells to display zero when worksheet option is ...

Hello,

I've done a bit of googling and can't find the answer so I figured I would ask the experts

I have a worksheet with options > advanced > display options for worksheet > show a zero in cells that have zero value disabled, so my worksheet isn't filled with zeros all over the place.

However, there are a very small number of calculation cells where I would like to see a zero if that is the value, instead of having the cell stay blank.

Everything I have found online describes how to display zeros if you have them hidden through cell formatting, which I do not. I am reluctant to change my cell formatting for the entire worksheet just to un-change them for a few cells--the worksheet contains a variety of custom cell formats, is too large, and works too well as is to change cell formatting in this way.

I've done a little quick experimenting with cell formats to see if there was a way to force zeros that way, but I could not find a solution.

Anyone have any thoughts how to accomplish this without changing the worksheet display setting?

Many thanks in advance.