How to change date format from yyyymmdd to mm/dd/yy in Excel?

Solved/Closed
lmw - Updated on Jan 26, 2019 at 03:32 AM
 Sf - Mar 28, 2018 at 06:57 AM
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

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!
60
Thanks
0
Its working ........Thank u so much
0
Much appreciated...worked great!
0
Awesome, exactly what I needed.
0
Thanks....
0