Rounding 1,000s
I have a budget where I rounded to the 1000's by taking the number and
dividing it by 1000.
So for example:
2,000,000 is now 2,000 (=2000000/1000)
The problem is ... Excel is not rounding correctly, please see below. How
do I fix this?
Example :
#/1000
253,462 253
127,033 127
34,500 34 (why did Excel round this down?)
28,633 29
443,627 444 on a calculator 443
Thank you,
|