View Single Post
  #1   Report Post  
Cheryl
 
Posts: n/a
Default Data Validation #VALUE

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.