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 the date format into general format - How-To - 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 - How-To - Excel
- How do i convert yyyymmdd to mm/dd/yyyy in excel? - Forum - Excel
- Excel convert date with dots to slash ✓ - Forum - Office Software
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
Subscribe To Our Newsletter!
