Excel formula for numbers

Question

Hi,&nbsp;What formula is there to show numbers in thousands. For example, if the number is:&nbsp;1,500,000&nbsp;I would want to show it as 1,500 (in thousands)&nbsp;Note that I do not wish to use the CTRL +1 and change the format

lorenzo · Answer

Hi&nbsp;Nihal_shah&nbsp;&nbsp;With&nbsp;1,500,000 in&nbsp;A1, in the cell is want: =A1/1000

nihal_shah · Answer

Lorenzo&nbsp;&nbsp;Thanks.&nbsp;I believe there is another formula apart from&nbsp;&nbsp;ROUND (CELL/1000,0)&nbsp;Please reconfirm&nbsp;&nbsp;

lorenzo · Answer

Nihal_shah&nbsp;&nbsp;No idea what you actually expect. Just provided a basic approach based on what you posted=ROUND(A1/1000,0) also works. The key question is: do you have numbers with decimals and what do you expect in this case???

nihal_shah · Answer

Please note that if I round a number to 1,000, it would obviously return decimals. If I have a formula which not only rounds the number to 1,000 without ROUND or what you proposed.

Forum Discussion

Excel formula for numbers

4 Replies

Resources