Share via

Unable to convert a Date in Excel

Anonymous
2023-05-25T21:57:01+00:00

Hi

I have received an excel spreadsheet from a supplier with Completion Dates column showing as Jan 11 2023, Nov 03 2022 etc.

I need to convert these dates to the format 11/01/2023, 03/11/2022 etc to allow uploading into our database as that's the only format that it will accept

When i check the format of each cell it says DATE.

I have tried changing to TEXT, GENERAL, CUSTOM FORMAT etc. but the format does not change from what is currently in each cell

Can anyone assist in how to convert this

Thanks

John

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-05-25T22:12:42+00:00

    Select the column with the dates.

    On the Data tab of the ribbon, in the Data Tools group, click Text to Columns.

    Select Delimited, then click 'Next >'.

    Clear all check boxes under Delimiters, then click 'Next >'

    Select MDY from the Date drop down.

    Click Finish.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-05-25T22:31:57+00:00

    Hi

    I have received an excel spreadsheet from a supplier with Completion Dates column showing as Jan 11 2023, Nov 03 2022 etc.

    I need to convert these dates to the format 11/01/2023, 03/11/2022 etc to allow uploading into our database as that's the only format that it will accept

    When i check the format of each cell it says DATE.

    I have tried changing to TEXT, GENERAL, CUSTOM FORMAT etc. but the format does not change from what is currently in each cell

    Can anyone assist in how to convert this

    Thanks

    John

    Image

    Thank you very much Hans that worked perfect

    0 comments