I have a long list of negative values. I sum them and get the figure -34368.83


I made a column next to it of the ABS() values of that column, so's I could remove the negative.

Then I copied that second column and pasted it for Values only.

So I have three column with the same numbers.

Column A the values are negative.
Column B the values are absolutes.
Column C the values are absolutes and without a formula.

Summing either of columns B or C gives the same value: but it is 42308.83 !

Lucky I saw the difference. What's the catch here?