View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DBB9 DBB9 is offline
external usenet poster
 
Posts: 2
Default Can surplus decimals be omitted when adding derived figures?

I have a column of calculated figures, displayed to 2 decimals. When Excel
2003 adds this it includes concealed decimals, creating a rounding error in
the total. How can I delete the excess decimals so they do not distort the
calculation?