IMPORT = incorrect format

Hi,
I would appreciate if someone could tell me why the format from Column D (row 66-97) is incorrect after I import a HTM page from the web. This is in reference to the attachment ENG.xlsx
The page I imported is;
https://www.soccerassociation.com/0/2223/A20220730.htm
At the bottom of the page there is a results section with scores from each game.
In the xls sheet that I have attached, some scores display as dates, i.e. 2-Jan (instead of displaying the score 1-2).
Any ideas how to correct this in terms of importing the score to display as a score and not as a date?
Muchly appreciated
John

Why would having the data in tabular format prevent you from manipulating it further after import??? Don't understand the logic behind that comment.

Sandy has imported the data using Get & Transform Data > From Web (on the Data ribbon) to access the data.

If you still have Excel 2010, you'd need to download the PowerQuery add-in.

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...nto-excel.html