I have inconsistent operation of data validation cells:I have two columns, C3 and E3, using data validation. Both configured the same except for the range (C3 is "=age", E3 is "=inseam").Validation data ranges are on a different worksheet.Both ranges are numbers, both columns are numbers (same problem if defined as general).If I manually enter a valid number under age, I get an error that age is out of range.If I manually enter a valid number under inseam, it is happy.Entering the same number using the drop down works for either.Why does entering data manually on age not work, but does on inse