Hi all,

I have a spreadsheet in which I have to sum some values. However, the outcome is always zero since Excel doesn't seem to recognize the values as values.
These values are originally values with a dot, which I've searches and replaces by a comma, because in the Netherlands, we use comma's as decimal point.
If I go INTO a cell with a value, and press enter, then it suddenly do see a value.
But, as I have thousands of cells with values, I was wondering if there is a better way to force Excel to see these cells as values.

TIA,

Annet