Thread: Rounding 1,000s
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
khen1 khen1 is offline
external usenet poster
 
Posts: 1
Default 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,