How to change date format from yyyymmdd to mm/dd/yy in Excel [Solved/Closed]
lmw - - Latest reply: Sf - Mar 28, 2018 at 06:57 AM
Related:
- Excel convert yyyymmdd to date
- Convert yyyymmdd to date - Best answers
- Convert yyyymmdd to mm/dd/yyyy in excel - Best answers
- Change date format dd.mm.yyyy to dd/mm/yyyy ✓ - Forum - Excel
- Change yyyymmdd format to mm/dd/yy in excel - Forum - Excel
- Convert date format in excel from yyyymmdd to mm/dd/yyyy ✓ - Forum - Excel
- Unable to change date format in Excel ✓ - Forum - Excel
- How to convert yyyymmdd to mm/dd/yyyy in excel - Forum - Excel
1 reply
Best answer
Solved my own problem! Here's how to do 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!
(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!
Glad we were able to help! Love us? Write us a review! Rate CCM
3008 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
Respond to Ram
Really great thing..
Report
Respond to Sf
Thank You amazing