Forum Discussion
Convert " Dec 30, 2019 " to Date Format
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 eve...
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.