MrExcel Publishing
Your One Stop for Excel Tips & Solutions

decimal places and $$$

Posted by SUsan on May 21, 2001 12:21 PM

Can anyone explain to me why addition and subtraction of $$$ would result in numbers about 12 spaces after the decimal point. The problem is that we're dealing with dollars and cents and doing only addition and subtraction. Therefore, I see no way we could get any number other than the first 2 decimal places. Does anyone have
any idea why this is happening? I can't just use ROUND for various reasons. Thanks. Susan

Posted by Connie on May 21, 2001 12:47 PM

You've probably already checked this, but do make certain that under Format>Currency, that "2" is chosen for how many places past the decimal. That's the only reason I could come up with that you'd be getting so many digits after the decimal.
Hope this helps.