You are seeing the correct total, because the cell formatting affects only
the display, not the underlying stored number.

Tools/ Options/ Calculation/ Precision as Displayed
would change your result, but be careful because it doesn't apply only to
the cells (or the sheet) that you've selected.

The safer option is to use =ROUND(A1,0) then add the results of those
calculations.
--
David Biddulph

"srikanth" wrote in message
...
I have used formating a cell using currency and making the decimal to Zero.
in the cell the numbers are being displayed in whole numbers but the total
of
these numbers are not the correct total. It is even calculating the
decimals
and then rounding off