Forum Discussion

paulinecuilleret's avatar
paulinecuilleret
Copper Contributor
Jun 04, 2020

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 everywhere , any help would be greatly appreciated!

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 04, 2020

    paulinecuilleret 

    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.