Incorrect Sum
I am having a problem summing a column of numbers. These numbers are both
negative and positive numbers. When I sum the numbers it comes to zero. This is correct, but when I reformat and take out a 30 decimal places I suddenly start getting numbers starting at about the 12th decimal place. These numbers are dollar amounts. I know they don't go beyond 2 decimal places. I've hand entered them. When I take all of the numbers out 30 decimal places, nothing shows up. It only does it on the sum. I tried summing only the negative numbers and postive numbers separately it works then, but I can do it this way for what I need to do. I've tried a bunch of things. Thanks Bill |
"AshlandPmac" wrote in message ... I am having a problem summing a column of numbers. These numbers are both negative and positive numbers. When I sum the numbers it comes to zero. This is correct, but when I reformat and take out a 30 decimal places I suddenly start getting numbers starting at about the 12th decimal place. These numbers are dollar amounts. I know they don't go beyond 2 decimal places. I've hand entered them. When I take all of the numbers out 30 decimal places, nothing shows up. It only does it on the sum. I tried summing only the negative numbers and postive numbers separately it works then, but I can do it this way for what I need to do. I've tried a bunch of things. Thanks Bill This link may help: http://www.mcgimpsey.com/excel/pennyoff.html /fredrik |
All times are GMT +1. The time now is 01:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com