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