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

Lorenzo

Silver Contributor

Oct 13, 2022

Hi Nihal_shah

With 1,500,000 in A1, in the cell is want: =A1/1000

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.