Ardus has told you how to solve the problem but has not explained why.
Computers store numbers in binary notation (base 2) and some decimal (base
10) numbers have no exact representation in binary when limited to 15
digits. For more read:
http://support.microsoft.com/kb/78113
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"dls2193" wrote in message
...
I have an issue with excel:

cell c7: 123200 (entered direct into cell-not calculated)

cell d7: -123151.6 (entered direct into cell-not calculated)

cell e7 forumula: =sum(c7:d7)

result displayed: 48.4 (appears correct)

cell j7 value = 48.4 (entered direct into cell-not calculated)

cell j7 formula: =j7=e7 result: FALSE

When I copy paste special values from cell e7 to another cell the result
is
48.3999999999942.

How can that be? What is the problem? This is simple math. It has been
tested on multiple computers with similar configuration. Please help.

MS office 2003 (11.6355.6408) SP1
MS Windows XP V2002 SP1

dls2193