The algorthm Excel uses for non integer numbers is a possible cause
I would use the round function to get the display you want.

"MattShoreson" wrote:


I have a text file containing values that I import into excel.

Once the values are in an excel sheet I do a sum of them all.
(currency - 2dp)

The final sum is displaying as 441992.489999999990000 - why would this
be?
None of the individual values show a greater degree of precision that
2dp!!!
In the text file there are no values with more than 2dp!

Why is excel calculating incorrectly.
I know I can do rounding etc. but what I want to know is why excel is
playing up!

CIA,Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=383481