Nihal_shahCopper ContributorOct 12, 2022Excel 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...Show More
LorenzoSilver ContributorOct 12, 2022Hi Nihal_shah With 1,500,000 in A1, in the cell is want: =A1/1000
Nihal_shahCopper Contributor to LorenzoOct 12, 2022Lorenzo Thanks. I believe there is another formula apart from ROUND (CELL/1000,0) Please reconfirm
