Jun 04 2020 03:38 AM
Hi all, I have an Excel with dates as "Dec 30, 2019", which I would like to convert to a format such as dd/mm/yyyy in order to then sort them (and their content in matching columns)
I've looked everywhere , any help would be greatly appreciated!
Jun 04 2020 04:44 AM
And what is Dec 30, 2019 - that's the text or the date formatted as mmm dd, yyyy ?
If the first and texts are in column, you may try Data->Text to Columns and on the third step of the wizard select Date and MDY. After that format dates as desired.