Menu
  1. Accueil
  2. Forum
  3. Office Software
  4. Excel

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

Report
-
 Sf -
Hello,

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?

Thanks!
System Configuration: Windows 7 / Firefox 7.0.1
See more

1 reply

Answer 1 / 1

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
59
Thank you

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

CCM 4132 users have said thank you to us this month

View all 11 comments
Report

Thank you!
Report

fantastic.... great help
Report

This is the best and easiest explanation I've seen! Thank you!
Report

Really great thing..
Report

Thank You amazing
Ask a question