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:  achovan
- Oct 20, 2017 at 04:59 PM
Hello,

I have data with dates arranged thusly: yyyymmdd

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

Thanks


See more 

10 replies

+49
Helpful
9
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!