I have a column with 240 lines (all numbers). I want to get the sum total.
When I higlight every number in the column, I get a total of 112,394.19.
When I use the summation formula it gives me a total of $127,578.735. Any
idea why there is a discrepancy? I tried formatting the cells so that the
numbers go out to 10 decimal places, but this didn't seem to make any
difference. Please help, this is driving me crazy!