Import porblem

[µ]

When i import data via a webquery from:
http://www.x-rates.com/d/EUR/table.html

I get different values than on the webpage..

When the webpage says:
American Dollar 1.3601 0.73524
Australian Dollar 1.62633 0.614883
Brazilian Real 2.75284 0.363261

I get these values in Excel:
American Dollar 13.601 0.73524
Australian Dollar 162.633 0.614883
Brazilian Real 275.284 0.363261

Some values are ten times to high, some are hunderd times to low.
Is this because in my version we use comma to seperate decimals?

So i see the value 13601 for the US$, and with the thousand
seperation, Excel turns it in too 13.601

How can i make Excel force to use the values from the webpage that
uses a point (.) where my version uses a comma (,) for decimals?

Thanks!

 

[Silvabod]

I tried this, which may help - you may be able to modify the method
..
I went to the http://www.x-rates.com/d/EUR/table.html site, selected the
table, copied into Excel.

I then re-copied the resultant hyperlinked table to another Excel area, but
"Pasted Special" (selecting the "value" option).
This gave a usable data table in standard format (decimal points as " . "
(point) not " , " (comma) without the embedded hyperlinks.

I am unfamiliar with an Excel set-up using "comma" as decimal point. Since
you are importing data in the conventional (decimal point) format into a
"comma" format, this may have the corrupting effect you mention - that's a
guess.

I emphasise that both the website table copy/paste into Excel, and the
subsequent copy/"paste_special" yielded accurate table copies - and my Excel
(2000) set-up and source data both use the decimal point.

Hope this helps!