View Single Post
  #3   Report Post  
Lee
 
Posts: n/a
Default

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?
.