?
Solved

Alternate way to enter dates in Excel

Posted on 2015-02-02
7
Medium Priority
?
83 Views
Last Modified: 2016-02-11
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
Comment
Question by:Bill Golden
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 16

Accepted Solution

by:
Carol Chisholm earned 1000 total points
ID: 40583792
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
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40583796
Hi

These are the basic ones to start with;
date format
Without dashes
without dashes
0
 
LVL 16

Expert Comment

by:Carol Chisholm
ID: 40583806
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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Author Comment

by:Bill Golden
ID: 40583810
Sorry, she is working in Excel 2003.....

And formatting the cell *3/14/2001 does not work....
0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40583811
did you try like this?
format
0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40583818
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
 
LVL 36

Expert Comment

by:Kimputer
ID: 40584275
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question