Try

=SUM(ROUND(E1:E648,2))

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sr Accountant" <Sr wrote in message
...
I open a text file in comma delimited, and then try to run a sum of 600+
lines. The following is returned -1.86825E-10 and the formula is written
as
=SUM(E1:E648)

If I remove the E1 and enter E2, my sum will be the opposite of E1. This
file is a General Ledger integration, so basically the number should be
zero,
and this is what I am trying to verify. The column format is General.
Does
anyone have any suggestions on why it does this?

Any help you can provide would be greatly appreciated.

Thanks!