>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
>
>520.0000
>238.6350
>127.3756
>456.2375
>--------
1342.2481

FoxPro

520.00
238.64
127.38
456.24
------
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