On our worksheets adding values with commas gives a result of zero as th
evalues are taken as text


"Bob Phillips" wrote:

Doesn't Excel automatically account for that, I have never found a problem
that I recall.


"DianeG" wrote in message
...
Hi

A client of mine works in the UK but deals with Austrian colleagues who
use
a comma instead of decimal point in their calulations. When he receives
the
spreadsheets he can't calculate in them. I was thinking around the lines
of
using find and replace to swap the commas but I wondered if anybody else
had
a more efficient way of doing it

Thanks in advance

Diane