Solved

Converting 20130116 to a US Date format in Excel

Posted on 2013-01-29
2
352 Views
Last Modified: 2013-01-29
I am dumping some information out of our ERP system into Excel.  Within our ERP system the date is written as 20130129.  Excel views this as a text field.  I need to covert this to a date format and have the date be shown as 01/29/2013.  Any suggestions on how to do this?
0
Comment
Question by:csimmons1324
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 38832802
If you have a column of data like that then the easiest way to convert is to use "Text to columns " functionality

Select column of data then use

Data > Text to columns > Next > Next > under "column data format" choose "Date" and  "YMD" from the dropdown > OK

Now you should have true dates which you can format any way you want

regards, barry
0
 

Author Closing Comment

by:csimmons1324
ID: 38832866
Great!  Thank you!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now