Change dates from uk format to us format

[June7]

Opened the workbook, changed nothing.
Date and USA Date columns are identical, except USADate shows 2-digit year: 5/13/2023 and 5/13/23.
Both columns show they are formatted for U.S.

[Welshgasman]

I might have just selected mm/dd/yy for the USA format.
However you should be able to change column A to be English date format?
Then try and import.

Edit: Yes, I can see from the pic in post #9 that is the format. That is just what Excel presents in the dropdown. One can sill specify mm/dd/yyyy as custom?, however two digit year should be fine. Just a format after all?