I configured excel 2007 to download data from the web. But the numbers are like this: 143,00 instead of 143 (example). So with these numbers are not considered as numbers and the calculations involving these have no value. The page I download has the format I mention above but in Excel 2010 I occasionally I use it is recognized and converted to 143 automatically. (again example). But the Excel 2007 I always use do not have this possibility.I would not upgrade to Excel 2010 just for this purpose - everything else works fine for me. One more thing to clarify - I use the Turkish format and in Turkish, the numbers thousands separator and decimal seperator are opposite (comma instead of dot and dot instead of comma) and foreign site downloaded web sites numbers can not be recognized. So is there any way to change the symbols to our desired format automatically after the page is downloaded every 2 minutes? And as an addition, In example some sites use some symbols such as 143.00- and the "-" symbols makes the number loose its number attribute thus no calculations can be made. I know "find and replace" but I want it to be automated each time the data refreshes.

Thanks for your input!.

ps. regarding the Turkish comma format I know control panel settings -- but it changes the whole system and all excel files. And some data downloaded has Turkish number format and some has US format so making a general change wont work.