Previous Topic Next Topic

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

Solved/Closed
Excel
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
Related:

1 reply

Answer 1 / 1
lmw
Updated on Jan 26, 2019 at 03:34 AM
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
Aye
Nov 12, 2013 at 06:31 AM
Thanks
0
Bharathi
Jan 30, 2014 at 03:44 AM
Its working ........Thank u so much
0
RWKL
Dec 23, 2014 at 01:50 PM
Much appreciated...worked great!
0
tw
Jan 7, 2015 at 11:16 AM
Awesome, exactly what I needed.
0
Kamal
Jan 9, 2015 at 11:24 PM
Thanks....
0

Similar discussions

Cannot change the date format in Excel 2007
Shayon -
Roja -

25 responses
Excel date format won't change
gto49 -
Peaches -

13 responses
Unable to change date format in Excel
rznbyz -
Tobby -

39 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Change date format dd.mm.yyyy to dd/mm/yyyy
shatrughna -
Ray -

47 responses
enter date in dd-mm-yyyy
sam -
fdibbins -

2 responses