?
Solved

Converting 20130116 to a US Date format in Excel

Posted on 2013-01-29
2
Medium Priority
?
361 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
[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
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

771 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