problem with decimal point

[groucho]

Hi,

When I make a web query and import eg. stock market values into a worksheet (Excel 2007), I can't use the cells in formulas because the decimals are separated by a point so excel doesn't recognize them as numbers. Formatting the cells doesn't help. I somehow need to tell Excel that the numbers in the worksheet in question have a point separating the decimals, or then maybe if there would be a way to change the point to a comma in every cell.

Or then the problem isn't the separator but something else. Anyway, when making a formula containing the cell, the value of the cell in the calculation is 0, even if it says '4.50'...

Does anyone have a solution to this problem?

Thanks in advance.