Wrong import values from webquerry

L

Ludo

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
 
L

Ludo

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
Click to expand...

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
 
Top