View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.