Related:
- Excel convert yyyymmdd to date
- Convert yyyymmdd to date - Best answers
- How to convert yyyymmdd to mm/dd/yyyy in excel - Best answers
- Excel convert yyyymmdd to mm/dd/yyyy - Forum - Excel
- How to convert yyyymmdd to date in excel - How-To - Excel
- Convert date format in excel from yyyymmdd to mm/dd/yyyy ✓ - Forum - Excel
- How do i convert yyyymmdd to mm/dd/yyyy in excel? - Forum - Excel
- Excel convert date to general - How-To - Excel
1 reply
lmw
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!
View all 11 comments
Report
dsfaklasdkf;alskhs;kd
Thank you!
Report
niz
fantastic.... great help
Report
achovan
This is the best and easiest explanation I've seen! Thank you!
Report
Ram
Really great thing..
Report
Sf
Thank You amazing
