Forum Discussion

Copper Contributor

Oct 13, 2022

Excel formula for numbers

Hi, What formula is there to show numbers in thousands. For example, if the number is: 1,500,000 I would want to show it as 1,500 (in thousands) Note that I do not wish to use the CTR...

Formulas and Functions

Nihal_shah

Copper Contributor

Oct 13, 2022

Lorenzo

Thanks.

I believe there is another formula apart from

ROUND (CELL/1000,0)

Please reconfirm

Lorenzo

Silver Contributor

Oct 13, 2022

Nihal_shah

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
Copper Contributor
Oct 13, 2022
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.