Wrong import values from webquerry
 

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

Wrong import values from webquerry
 

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