When comparing the number from our business application written in Visual FoxPro, we have come accros a problem that we find disturbing.


In the following, Excel is adding the true value of the numbers before it rounds to 2 decimals.

Excel Foxpro

520.0000 520.00
238.6350 238.64
127.3756 127.38
456.2375 456.24
-------- -------
1342.2481 1342.26


The cells in Excel are formatted to "Currency" which shows 2 decimals by default. The value of the cells is a sum of a calculation. example: =A1*B1 etc...

The Foxpro figures are added using the totals after rounding.

Which are the currect figures to use? Or how do you make Excel round to the 2 decimal before it adds the figures.

Please let me know if this an Excel bug or are we attempting to be to close with the numbers.

Thank You
stripe@cybertron.com