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:  Sf
- Mar 28, 2018 at 06:57 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 

12 replies

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!

Thank you, lmw 52

Something to say? Add comment

CCM has helped 1800 users this month

dsfaklasdkf;alskhs;kd - Jun 20, 2017 at 02:25 PM
Thank you!
fantastic.... great help
This is the best and easiest explanation I've seen! Thank you!