Windows 10: Copy-paste tables from website - comma issue

Any suggestions as to how to copy-paste tables from websites and have the comma removed (or changed to into a dot) ?
Copy 1,000,000 from a website results in 1 in Excel, i.e. 1 (one) instead of 1 million.
Note: Windows > Control Panel > Region > Advanced format > Customise format: digit grouping symbol reads dot.




:)

 

Copy-paste tables from website - comma issue

Any suggestions as to how to copy-paste tables from websites and have the comma removed (or changed to into a dot) ?
Copy 1,000,000 from a website results in 1 in Excel, i.e. 1 (one) instead of 1 million.
Note: Windows > Control Panel > Region > Advanced format > Customise format: digit grouping symbol reads dot.

 

Copy-paste tables from website - comma issue

Am I misunderstanding something here? I have no issues in keeping the original number formatting.

I copy the numbers, then paste in Excel keeping the original formatting:




(Click to enlarge.)

 

Copy-paste tables from website - comma issue

Hi there
I think the OP wanted not 1,000,000 to be copied as 1,000,000 but 1.000.000 --- you have to muck about with some regional / language/editing settings in EXCEL -- UK English for example will treat 1,000 etc as 1 (USA too I'd imagine and most other variants of English) since it will assume the comma is the decimal separator rather than '.' i.e 1,07.00 for example rather than 1.07,00

Cheers

jimbo