Don't the #value's only momentarily show up. Then you get the warning message
from the Data|Validation check.

Then as soon as you hit Retry or Cancel, the #values turn back to the previous
value?

I wouldn't worry about it, but you could change your formulas...

=if(istext(a1),"",yourformulahere)

Just to hide those #values (for just a moment).

Cheryl wrote:

Even though I have data validation to accept only whole numbers, if a user
accidentally enters text, other cells that contain formulas based on this
cell change to #VALUE. The text is not allowed to be entered in the cell,
but the formulas in the other cells apparently read that text.

--

Dave Peterson