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
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 

12 replies

+51
Helpful
11
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!
fantastic.... great help
This is the best and easiest explanation I've seen! Thank you!