Convert American date format to British date format

[jungle125]

Hi

I download a CSV file and it shows dates in the American format mmddyyyy. I would like to convert this to the British format ddmmyyyy. What´s the easiest way to do it?
I have tried playing around with formatting the cells and I´ve done a seach on this forum, but was not able to get a clear and easy answer.

Thanks in advance for any help.

Date
05/18/2023
05/17/2023
05/16/2023
05/15/2023
05/12/2023
05/11/2023
05/10/2023
05/09/2023
05/08/2023
05/05/2023
05/04/2023
04/28/2023
04/27/2023
04/26/2023
04/25/2023
04/24/2023
04/21/2023
04/20/2023
04/19/2023

 

[alansidman]

Data-->Text to Columns-->Next-->Next-->DMY in the Date Box-->Finish. Note: This only works if the data is formatted as Dates and not Text.

 

[MARK858]

Needs to be in the format it appears in the cell for the Text to Columns i.e. MDY then format the cells to the UK format (it should convert text as well as numbers)

 

[jungle125]

Hi Alan

Thanks for the quick reply. That worked, but strangely enough I had to select MDY in the date box to change it to DMY in the spreadsheet.

Have a great weekend!

 

[alansidman]

Thanks for the feedback. Glad it worked for you.

 

[Alex Blakenburg]

Hi Alan

Thanks for the quick reply. That worked, but strangely enough I had to select MDY in the date box to change it to DMY in the spreadsheet.

Have a great weekend!

Not actually that strange, you need to tell it what format you are converting "from" which was the American format MDY