[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 91
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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