How to change date format from yyyymmdd to mm/dd/yy in Excel [Solved/Closed]
lmw -
Oct 21, 2011 at 03:25 PM - Latest reply: Sf
- Mar 28, 2018 at 06:57 AM
- How to change date format in excel
- Excel convert yyyymmdd to date
- Change date format in excel
- Unable to change date format in Excel [Solved] (Solved) » Forum - Excel
- Change Date Format in Excel » How-To - Excel
- Change date format dd.mm.yyyy to dd/mm/yyyy [Solved] (Solved) » Forum - Excel
- Changing format of date in Excel [Solved] (Solved) » Forum - Excel
- I want to change date format in Excel [Solved] (Solved) » Forum - Excel
12 replies
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!
has helped 1800 users this monthView all 11 comments
Report
Thank you!
Report
Respond to niz
fantastic.... great help
Report
Respond to achovan
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