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

 Sf -

I have data with dates arranged in yyyymmdd format.

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

System Configuration: Windows 7 / Firefox 7.0.1

1 reply

Hey folks,

I solved my own problem! Here's how I did 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

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thank you!
fantastic.... great help
This is the best and easiest explanation I've seen! Thank you!
Really great thing..
Thank You amazing

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!