Error with decimals

Giganews Newsgroups
Subject: Error with decimals
Posted by:  Leamsi
Date: Thu, 18 May 2006

Has anyone notice a problem with up decimal, somehow excel adds up more
decimals.
eg.

cell (A1)  5045.3
cell (A2)  5045.03
cell (A3) =A1-A2

Note that the diference will be .27
But excel brings 0.270000000000437

Replies