How to convert list of different numbers to thousands

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1,343,777 236,675 2,694,710 1,357,500
1,343,777 236,675 2,694,710 1,357,500
1,343,777 236,675 2,694,710 1,357,500
1,343,777 236,675 2,694,710 1,357,500
0 0 1,875 0
0 0 1,875 0
0 0 1,875 0
0 0 1,875 0
0 0 0 53,200
65,794 63,948 84,977 89,945
80,547 87,757 79,360 72,901

For example this list of numbers what is the fast way to convert them in
thousands e.g. 1,343,777 in thousands 1,344. thanks for your help Liana.
 
To convert them:

=ROUND(A1/1000,0)

If you just want to DISPLAY thousands:

Format/Cells/Number/Custom #,##0,
 
If you want the actual values changed....

Try this:
Enter 1000 in a blank cell
Ctrl+C........a shortcut for <edit><copy>

Select the range of cells to be impacted.

From the Excel Main Menu:
<edit><paste special>
Check: Divide
Click [OK]

That will divide each of the selected cells by 1000

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
=ROUND(A1/1000,0)
If you don't want to change the number, but merely change the display, try a
custom format such as #,##0,
 
Back
Top