How to fix these dates?

[danhendo888]

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=J87rl6[/FONT]


How best could I go about fixing this column so that it shows dates.
The bottom half is in text format.
Thanks all.

 

[Michael M]

The link suggests they are simply left aligned ?
Is there a leading apostrophe in the Text dates ?
Put this formula in col "B" and copy down....if they are a date it will return true

=LEFT(CELL("format",A1))="D"

 

[danhendo888]

I uploaded the spreadsheet again.

A2:A6 shows dates in MM/DD/YYYY format
A7:A9 is in DD/MM/YYYY format but Excel doesn't recognize them as dates.

When I sort, this is the output.
Looking for a way to convert column A to dates.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=EqCqDj[/FONT]