Convert to # in Thousands
 

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

Hi

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

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

Cheers
JulieD

"CCB AA" wrote in message
...
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

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 editpaste special and select divide, then while still selected
do formatcellsnumber, select zero decimal places
finally do toolsoptionscalculation 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

"CCB AA" wrote:

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

Enter 1000 in a cell.

Copy that cell.

Select cells to convert.

EditPaste SpecialDivideOKEsc.

Format cells to no decimal places.

Gord Dibben Excel MVP

On Wed, 22 Dec 2004 08:25:07 -0800, CCB AA
wrote:

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