non uk date format

[Trevor3007]

I have been given a excel spread sheet & the dates are showing as below:-

03/01/2024
03/02/2024
etc

I need the dates to be in the UK format :-

01/03/2024
etc

I have tried to format , but still they remain in the non UK format!!

The above is just a sample , there are rows & rows of dates & therefore I need a a formula that will save me the 'manual' boring task.

Thanking you in advance

 

[Fluff]

You can use text to columns, delimited, next, clear all checkboxes, next, select MDY from the date drop-down, Finish.

 

[Trevor3007]

thank you fluff, but that did not work. I tripled checked your sugg, but still it remains nin uk :{

much appreciated though.

 

[Fluff]

Did you select MDY rather than DMY?

 

[Trevor3007]

i indeed did choose dmy ...DOH

thank you.

 

[Fluff]

You're welcome & thanks for the feedback.