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
Susan,
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.
