Hello,

I have a formula that uses ISERROR to replace null values with a zero. I
run and access query to get the data, and paste it into the sheet - and the
ISERROR has run correctly for years to look for null values and replace them.
However, recently, this has stopped working. It's as if there is a value in
the cell that I cannot see. When I double click in the cell, then click out
of it - it seems to remove whatever value or formatting is there and the
ISERROR works correctly. Has anyone run into this before? I'd like to
understand what is happening in these cells, and why simply double clicking
in and out of them seems to remove the problem.

Thank you,

Nacho