Once you've hidden the 0's, I don't think you'll be able to make them appear --
even with a macro.

I think I'd take the opposite approach. Show all the 0's (check View Zeros).

But then hide the 0's you don't want to see--either using format|conditional
formatting (white on white) or by using a custom number format:

General;-General;;

ps. What do you mean by column 0 and row K?

teresa wrote:

In my spreadsheet I have unticke the "View Zeros" option but I need all
values in column O and row K to show zeros, I need a macro to condition
this for these
particular cells

Thanks

--

Dave Peterson