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!