How to change date format from yyyymmdd to mm/dd/yy in Excel [Solved/Closed]

lmw - Oct 21, 2011 at 03:25 PM - Latest reply:  Ram
- Jan 24, 2018 at 03:10 AM

I have data with dates arranged thusly: yyyymmdd

Is there an easy way to change the format to mm/dd/yy in Excel 2010?


See more 

11 replies

Solved my own problem! Here's how to do it:

(If dates are in a row, select row, copy, paste/ transpose to a new column [no header])

Select the column.
Choose Data tab
Text to Columns - opens new box
(choose Delimited), Next
(uncheck all boxes, use "none" for text qualifier), Next
use the ymd option from the Date dropdown.
Click Finish.

You're done!
Was this answer helpful?  
Thanks soo much
fantastic.... great help
This is the best and easiest explanation I've seen! Thank you!