Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,118
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.misc
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format numbers to thousands James7100 Excel Discussion (Misc queries) 1 October 12th 06 12:45 PM
Convert Hundreds to Thousands abs Excel Discussion (Misc queries) 2 April 5th 06 05:06 PM
How do I format numbers in thousands? Barb Excel Discussion (Misc queries) 0 February 6th 06 10:34 PM
How do I format numbers in thousands? bpeltzer Excel Discussion (Misc queries) 0 February 6th 06 10:30 PM
Convert to # in Thousands CCB AA Excel Worksheet Functions 3 December 22nd 04 07:35 PM


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"