Sum problem

A

Alberto

Hi all.
I have this strange problem :
first of all I have EUROPEAN setting, I mean that :

2000000,00 = two millions
2,40 = two + 4 tens

if I put 2000000.00 ( look i write 0.00 and not 0,00 this
is an error 2000000.00 is not a number ) in cell A1
if I put 2,40 in A2 and in A3 i set A3 = SUM(A1,A2) i have
no error but a sum = 2,40.
If i change 2000000.00 in 2000000,00 the sum in correct :
2000012.00
My concern is about the wrong sum, if I have an Excel
Sheet built from some erxternal program ( Host program as
example) I can have wrong sums WITHOUT WARNING.

Can someone explain me something about this, and of course
haw to avoid tghe silen error sum.

Alberto
 
A

Arvi Laanemets

Hi

Select the range with data. Activate Search/Replace wizard, into SearchFor
field enter '.', into ReplaceWith field enter ',', and press ReplaceAll. All
periods in selected range (or on whole sheet, when a single cell was
selected) are replaced with commas, and with your settings, are converted to
numbers.
 
B

Bernard Liengme

SUM ignores text so with A1=dog and A2 = 24 the formula SUM(A1:A2) gives 24
but the formula A1+A2 give a #VALUE! error
 
Top