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

Ask a question lmw - Last answered on Aug 15, 2017 at 04:48 AM by niz

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 
plus moins
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!
tw- Jan 7, 2015 at 11:16 AM
Awesome, exactly what I needed.
Kamal- Jan 9, 2015 at 11:24 PM
Kun- Jan 22, 2015 at 12:37 PM
Thanks soo much
dsfaklasdkf;alskhs;kd- Jun 20, 2017 at 02:25 PM
Thank you!
niz- Aug 15, 2017 at 04:48 AM
fantastic.... great help

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!