csimmons1324
asked on
Converting 20130116 to a US Date format in Excel
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER