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


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 

1 reply

Best answer
Thank you
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!

Say "Thank you" 54

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 3008 users have said thank you to us this month

Thank you!
fantastic.... great help
This is the best and easiest explanation I've seen! Thank you!