View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgruening
 
Posts: n/a
Default Rounding with the sum formula


I have the cells in a cloumn set to zero decimal places however when I
use the SUM in the same column it seams to be rounding up.

Does anyone know how to get the SUM just to add the visible number in
each cell in that column without doing any rounding?

Thanks

Peter


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=497395