Date input mask

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Is there a way to make an input mask so that a date
entered in 1 column is something like mm/dd/yy? I have
used the format cell approach but it still allows me to
enter other tex. I want it so the only thing entered is
the date.

Thanks.
 
Validation is one way although it is easily overwritten if
the user copies a cell and pastes over the validation
cell. Nevertheless, under Data > Validation, choose Custom
and insert:

=(MID(A1,3,1)="/")*(MID(A1,6,1)="/")*(ISNUMBER(A1*1))

HTH
Jason
Atlanta, GA
 
Back
Top