How to change date format from yyyymmdd to mm/dd/yy in Excel?
Solved/Closed
Related:
- Excel convert yyyymmdd to date
- How to convert yyyymmdd to mm/dd/yyyy in excel - Best answers
- Convert yyyymmdd to date - Best answers
- Help to convert a date to julian date fromat yyyyddd in excel ✓ - Forum - Excel
- Change yyyymmdd format to mm/dd/yy in excel - Forum - Excel
- How to convert date format in excel from yyyymmdd to dd/mm/yyyy - Guide
- How to convert yyyymmdd to mm/dd/yyyy in excel - Forum - Excel
- How to change mm/dd/yyyy to dd/mm/yyyy format in excel - Forum - Excel
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])
You're done!
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!
Nov 12, 2013 at 06:31 AM
Jan 30, 2014 at 03:44 AM
Dec 23, 2014 at 01:50 PM
Jan 7, 2015 at 11:16 AM
Jan 9, 2015 at 11:24 PM