When you're summing the final figures you're not summing what you can see but
the actual results of the formulas, so it's taking into account all of the
dp's.

Surely, you'd want an accurate number for your final sum, no matter what the
'rounded' sums show?

HTH.

"Dilys Duplock" wrote:

Using Excel 2003
I have a spreadsheet with general sum formulas in several columns. All
columns are formatted to show 2 decimal points only. When I add up the final
column (wth a formula or by blocking/choosing sum on the bottom bar) the
total has taken account of all the extra decimal places and added these in
thereby giving the wrong total of the column. In some cases the totals also
do not add up along the row either because of the same problem!