Convert to # in Thousands

[CCB AA]

Spreadsheet - for calculations, I need to convert numbers like 160,953,000
and 161,524,619 to 160,953 and 161,525 -- Customized changed the appearance
of the number but not the number itself

 

[JulieD]

Hi

using Round
e.g.
=ROUND(A1,-3)/1000

with your value in A1 or
=ROUND(160953000,-3)/1000

Cheers
JulieD

 

[Peo Sjoblom]

You could use a help column and

=ROUND(A1/1000,0)

then copy and paste special as values

or put 1000 in a cell, copy it, select the numbers,
do edit>paste special and select divide, then while still selected
do format>cells>number, select zero decimal places
finally do tools>options>calculation and select precision as displayed.
Then turn it off again. I would probably do this first on a copy of the
workbook



Regards,

Peo Sjoblom

 

[Gord Dibben]

Enter 1000 in a cell.

Copy that cell.

Select cells to convert.

Edit>Paste Special>Divide>OK>Esc.

Format cells to no decimal places.

Gord Dibben Excel MVP