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?


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!
Was this answer helpful?  
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!