Data Validation to force a Date/Time Entry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Data validation error with multiple CPU 3
Special converting of string date&time to date format 4
Forcing a date entry format of dd/mm/yyyy 1
How to enter a date in DD-MM-YYYY format 2
Data Validation With Date Range 2
Data Validation and Today's Date Probelm ? 1
Data Validation and Current Date ? 4

Top