Forum Discussion
Solved
How to make the format of date from 1/1/2022 to 2022/1/1?
How to make the format of date from 1/1/2022 to 2022/1/1? Thank you for your feedback.
It looks like you have texts in column A, not dates. If so, you may convert them to dates by selecting column A, Data->Text to Columns, on third step of the wizard select Date and MDY.
I'm not sure if I'm missing any data processing. I couldn't get the date sorting as C column. I listed what i need as the C column (by manual). Thanks for your comments.
It looks like you have texts in column A, not dates. If so, you may convert them to dates by selecting column A, Data->Text to Columns, on third step of the wizard select Date and MDY.
SergeiBaklan Thanks for your comments. Great to learn.
SusanHung , glad to help