Data Validation to force a Date/Time Entry

  • Thread starter Thread starter DoctorV
  • Start date Start date
D

DoctorV

I have a cell where the user must enter a date time like this

5/1/2004 6:35 PM

How can I force them to enter a proper Date and Time? Are there an
Input Masks like you can use in Access? When I've tried and use
Custom Data validation it can let them get by with just entering th
date

Are there any free calendar/clock controls ActiveX for Excel
 
Back
Top