View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.