Error when importing excel

[Happyz]

I couldn't see any difference to the original Excel file ....

I've spent about 30 minutes trying different ways of fixing your dates:
See below & attached file

Nothing I tried worked.
I'm not saying its impossible to fix but I've spent too long on it already

My suggestion is to abandon trying to fix it & re-enter the dates
Insert an extra column in Excel, format it as UK date e.g. dd/mm/yyyy then re-enter the data correctly
Once that is done, delete the original data in column B

Thank you, I tried re-enter the dates and it works perfectly now!

 

[Happyz]

The only solution I can come up with just now is Copy and Paste method.
All other solutions I've look at could save one problem but then another problem occurs.
Click the "Copy from Excel" button, the result is saved in Book2 table.

Thank you!