Reformat date in column

[roof16]

Hi,
I have a large number of transactions and the column for the date has the format incorrect and I am unable to change it to the proper format even using the custom formatting.
Below is a paste for an example. The sheet feels the first two digits are the year, in actuality it is the day.
I need this formatted properly as I need to sort the 700 odd lines by date.

Any suggestions is appreciated.

Thanks

02-SEP-19

28-MAR-19

21-FEB-19

08-AUG-19

03-JAN-19

01-APR-19

01-NOV-19

11-MAR-19

23-OCT-19

 

[Fluff]

Select the column then goto to Text To Columns on the data tab, Delimied > Next > Uncheck all boxes > Next > Select DMY from the date drop down > Finish.

 

[roof16]

Select the column then goto to Text To Columns on the data tab, Delimied > Next > Uncheck all boxes > Next > Select DMY from the date drop down > Finish.

Thank you! That did it, after searching google for days...

 

[Fluff]

You're welcome & thanks for the feedback.