"Lock down" date formating

  • Thread starter Thread starter Jumbo Shrimps
  • Start date Start date
J

Jumbo Shrimps

I need to ensure dates entered into certain
cells are in "##/##/##" only.
If for example, someone enters
"Dec. 10, 2003" in the cell,
an error message should remind them to
enter that date as "##/##/##".
 
Jumbo

If you use Data Validation, and set it to a date between 01/01/1900 and
today(), whatever is typed into the cell, datewise, seems to be converted to
##/##/## format for you!!

Andy.
 
Back
Top