date input mask

D

dagibbie

In Access you can create an input mask for the data entry of phone numbers,
dates and other numbers that need a hypen or slash. This makes data entry
quicker. Is there a way in Excel to do the same. I have a large number of
dates to enter and do not want to have to stop and use a hypen or slash to
separate the day, month and year.
 

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

how to set up a mask to enter a code, ie ###-##-####-###-###-##-#. 1
Date Issue 4
Date input format 2
input mask 2
Custom, Automated Input Masks 2
Remove input mask format 4
Excel Vba to change displayed year automatically. 14
Input mask for date! 0

Top