Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Excel 2007 adding a column of negative and positive number
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Bzltyr, post: 3248388"] I have a column of 4600 number that should equal zero as they are for entering journal entries so they must balance to zero. I have done functions: roundup, rounddown, trunc, mround, and the individual cells show only two decimal pionts for example 4,120.33. when I add the column it adds up to zero until I start expanding the zeros after the decimal. When I get to about six places right of the decimal there is a value. None of my numbers have any values beyond two decimal places. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Excel 2007 adding a column of negative and positive number
Top