• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 94
  • Last Modified:

Alternate way to enter dates in Excel

I have someone who will be entering about a thousand dates in an Excel spreadsheet.  Is there a way to enter the date as:

1. mmddyy,
2. yymmdd
3. or in any other order that DOES NOT require entering a / or - or some other separator?
0
Bill Golden
Asked:
Bill Golden
1 Solution
 
Carol ChisholmCommented:
You could have them entre them in any format and use a formula to convert to a date format.
However it is best to use the numeric keypad to enter them with a / or - so that they can see that date is valid before going onto the next one.
0
 
Wilder1626Commented:
Hi

These are the basic ones to start with;
date format
Without dashes
without dashes
0
 
Carol ChisholmCommented:
If your date is in A1 and is in the format yyyymmdd then the formula to make a date is =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Bill GoldenExecutive Managing MemberAuthor Commented:
Sorry, she is working in Excel 2003.....

And formatting the cell *3/14/2001 does not work....
0
 
Wilder1626Commented:
did you try like this?
format
0
 
Wilder1626Commented:
For the 2003 version, you will go under Format / Cells.
Make sure to select the column you want to apply your new format before you change the format.

formats
0
 
KimputerCommented:
Use VBA, when clicked on the row or column that needs a date, open a userform with a MS Monthview control. NO typing needed on the user side, no FORMATTING errors by the user. Of course, that means you can't yell at the anymore like "OMG you switched the day with the month", since the user probably didn't make that mistake to begin with, or at least very not likely.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now