Perhaps the "somewhere else" may have non-integers formatted as integer?

is it just paste, or paste special?


"Dave Peterson" wrote in message
...
I also get 4,496,180.

How about formatting those cells to sum as General and widening the
column.
Maybe some of the decimal portions are hidden (by format or by column
width).



dwright wrote:

Open an Excel spreadsheet, format a column as numeric, no decimals, and
paste
in the following 8 values:

442,528
1,477,789
17,942
130,714
84,053
524,606
1,724,962
93,586

Sum them. You will get the answer 4,496,179. The correct answer is
4,496,180. I would suggest you incorporate round-off error correction
routines in your math calculations. This is strictly a newbie error, and
I'm
frankly amazed that you haven't caught it yet.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson