On 2 jan, 22:32, Ludo wrote:
Hi,

I have a problem with a currency converter webquerry import.
I do an import from following site:http://www.x-rates.com/d/DKK/table.html
and select the Danish Krone table.
Then i select import.
So far everything works great, but when i check the imported values,
then i see that some currencies are totally wrong :(

Example of correct currencie:
* Chinese Yuan * * * * * *1.09678 * * * *0.911761
* Croatian Kuna * * * * * 1.01356 * * * *0.986621
* Norwegian Kroner * 1.04312 * 0.958666
* Philippine Peso * * * 7.62804 * 0.131095
*South African Rand *1.40713 * 0.710666
*Swedish Krona * * * * 1.20098 * 0.832651
* Thai Baht * * * * * * * * 5.48302 * 0.182381

Example of wrong imported currencie in Excel 2007:

* Chinese Yuan * * * * * * 109.678 * * * 0.911761
* Croatian Kuna * * * * * *101.356 * * * 0.986621
* Norwegian Kroner * *104.312 * *0.958666
* Philippine Peso * * * * *762.804 * * * 0.131095
* South African Rand *140.713 * *0.710666
* Swedish Krona * * * * * *120.098 * * * 0.832651
* Thai Baht * * * *548.302 * * * 0.182381

Note the wrong location of the decimal point in the values.

I tried to change the cell propertie to TEXT, but this doesn't change
a thing.

What is here going wrong?

I realy need it working on a European settings PC & a USA settings PC,
and prefer (if possible) without any macro's.

Anyone out there that can help me with this weird behaviour?

I'm working on a Dutch Excel 2007 on a VISTA PC
Querry import is with the default settings.

any help is welcome.
Best Regards,

Ludo

Hi,

i think it's partly solved.
i tried it at the pc in the company and there it's working (XL 2003).
But when i change in OPTIONS - International the checkbox to "Use
system separators", it behaves just like at home (wrong currency
values).
So i need to figure out where i can find those settings in XL2007 to
check the settings and change them if needed.

Best regards,
Ludo