Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions |