Excel/Access 2002 sum function

[Guest]

from my access databaes I export information to excell. when prices get to
excell the numbers get changed. (300.00 changes to 299.0099999999900) the
change is taking place between the 3rd and 10 decimal place and all of my
access and excel formating is only to the 2nd decimal. can anyone help on
this?

 

[Nick Hodge]

Michael

Formatting does not change the actual number so the number that is
transferring to Excel is either that number or a calculation that results in
that number, to be sure that you only have x number of decimals you should
use the ROUND function

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)