Date input mask

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.
 
J

Jason Morin

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
 

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

Date Format 10
VBA - exporting serial letters to single documents 0
Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
How to enter a date in DD-MM-YYYY format 2
How to add day to PWA 2016 date format? 0
Drop-down calendar for sheet 0
Data Validation Date Format 2
date mask via vba? 3

Top