Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wrong Hyperlink-Values | Excel Programming | |||
Wrong import of float data | Excel Discussion (Misc queries) | |||
Wrong result on dividing 2 values | Excel Worksheet Functions | |||
Getting wrong values | Excel Worksheet Functions | |||
Data import gives the wrong values: bad text format? | Excel Programming |