Yikes! My bad. I went back to the original data to confirm my statement
that nothing had ever been anything but an integer, and I was WRONG. The
actual original inputs we

442527.6
1477789.2
17942.4
130713.6
84052.8
524606.4
1724961.6
93585.6

Hence, my premise was wrong. I apologise to the community for my error.

"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