I have set up my data validation for whole numbers greater than 0. I tried
entering the date and it works. Why would the computer considered a date a
whole number?
Te',
Format a cell as date, enter date.
Now change format of cell to number.
:-) see
hth
> I have set up my data validation for whole numbers greater than 0. I tried
> entering the date and it works. Why would the computer considered a date a
> whole number?