Hello,
I have a problem with the Data Validation tool.
I have a column where the user has to put a date in the dd/mm/aaaa format.
I have set Validation data in this area to: Allow Date not equal to 1/1/1900, with the message and alert ticked.
If I format the cells to General, Validation data lets a user enter a whole number without alerting, and it stays as a whole number in the cell.
If I format the cells to Date jj/mm/aaaa, the whole number entered by the user is transformed to a (false) date and Validation Data doesn't alert him neither.
What should I do?
Thanks
Bookmarks