How to convert list of different numbers to thousands
 

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.

How to convert list of different numbers to thousands
 

To convert them:

=ROUND(A1/1000,0)

If you just want to DISPLAY thousands:

Format/Cells/Number/Custom #,##0,



In article ,
Cardeth@Work wrote:

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.

How to convert list of different numbers to thousands
 

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)
"Cardeth@Work" wrote in message
...
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.

How to convert list of different numbers to thousands
 

=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,
--
David Biddulph

"Cardeth@Work" wrote in message
...
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.