Hi

1200 and one of 700 are numbers, another 700 and 800 are texts.

1.Format the range with your numbers as numeric or general;
2. Into some empty unformatted cell somewhere enter a number 1, and copy the
cell;
3. Select the range with your numbers, and Paste Special as Multiply - now
your formula must return right result;
4. Clear the cell you used to store number 1.


Arvi Laanemets


"mlv" wrote in message
...
When adding a column of numbers, the sum function failed to accurately sum
the numbers. Even summing just 1200, 800, 700, 700 yielded 1900. How do
I
correct this internal error?