Pasting web tables into Excel - help needed!

I copy/paste web table from IExplorer.

The table contains many numeric values, all with 2 decimal spots, for example 1.20, 3.40, 5.60 etc. - standard European way of displaying odds on sporting events.

The problem is that these tables pasted in Excel instead of showing numeric values convert all those 1.20, 3.40 numbers into dates and I get jan.06, mar.40 etc.

The same table pasted into Word leaves the numbers formated as they are in IExplorer!

So my question is Can I paste that table in Excel and have Excel keep the numbers instead of converting them to dates?

It doesn't help as all the cells that hold jan.10 for example or any other date are converted to number representation of the day which is number of days passed since 1/1/1900 and cells that should hold 1.20 and are after pasting changed to jan.20 convert to something like 45395

Originally Posted by Riorin

It doesn't help as all the cells that hold jan.10 for example or any other date are converted to number representation of the day which is number of days passed since 1/1/1900 and cells that should hold 1.20 and are after pasting changed to jan.20 convert to something like 45395

There must be something wrong with the time setting on your pc, because if you format 45395 to a date you get 13/04/2024 not 20 Jan?

I found it myself I had . (dot) as date separator in Control Panel, Regional settings and after changing it to something like # it doesn't convert digit.digit to dates.