LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
How I need correct formula, that no t rounding? TANDEX Excel Worksheet Functions 2 July 15th 05 07:30 PM
Rounding formula won't copy to other cells in column - why? LindaO Excel Discussion (Misc queries) 4 July 11th 05 10:57 PM
How do I get my formula to stop rounding up SheltieGrl Excel Worksheet Functions 1 March 11th 05 06:23 PM
Price rounding - exception formula required Alex McCourty Excel Worksheet Functions 2 November 6th 04 08:33 AM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"