Input Mask for Dates

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

Can I apply an input mask or custom format to cells so
that users do not have to type the slashes for date
entry? Thanks!
 
You can use some VBA code that will interpret a date that
is entered with out "-" or "/". See Chip Pearson's site:

http://www.cpearson.com/excel/DateTimeEntry.htm

Or you could use allow the user to key in a 5 or 6 digit
date such as 10399 (Jan3,1999) or 100704 (Oct7,2004) and
then convert it to a real date in another cell using:

=REPLACE(REPLACE(A1,LEN(A1)-3,,"-"),LEN(A1),,"-")*1

and format as mm/dd/yy.

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 input mask 1
Date input format 2
Input Mask for Dates 5
Reformatting dates for sorting 2
How do I create a date format 2
Input mask for date! 0
Formatting cells to only upper case 5
Enter date without slashes 9

Back
Top