Are the numbers actually rounded off using the ROUND
function or are the cells just formatted to show 2 decimal
places?
Lee
-----Original Message-----
How do I get Excel to correctly add a column of numbers
that have each been
rounded to 2 decimals? It seems to always remember the
unrounded figures;
therefore, the sum of the column of figures is never
correct. It's always off
a few decimal points. This seems an amazing short-coming
for a spreadsheet
program. Is there a fix for this problem?
.
|