Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mary
 
Posts: n/a
Default multipy group of numbers

is there a quick way to multipy a large group of numbers by 1,000?
  #2   Report Post  
Mary
 
Posts: n/a
Default

Further explanation, I have different numbers in about 2500 cells. I want to
multiply each number times 1,000 and have that product of the # in the cell
times 1,000 present in the cell.

"Mary" wrote:

is there a quick way to multipy a large group of numbers by 1,000?

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Put 1000 in an empty cell.
copy that cell
select your range of cells to adjust.

Edit|paste special|check multiply

Clean up that helper cell.

Mary wrote:

Further explanation, I have different numbers in about 2500 cells. I want to
multiply each number times 1,000 and have that product of the # in the cell
times 1,000 present in the cell.

"Mary" wrote:

is there a quick way to multipy a large group of numbers by 1,000?


--

Dave Peterson
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
Need help w/ Weight Formula Tom Excel Discussion (Misc queries) 3 March 4th 05 05:23 PM
Need help w/ "Weight Formula" Tom Excel Worksheet Functions 0 March 2nd 05 06:55 PM
count a group of numbers but do not count duplicates Lisaml Excel Worksheet Functions 2 January 26th 05 11:19 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM
Working with a large group of numbers Majoe4 Excel Worksheet Functions 1 December 10th 04 07:29 PM


All times are GMT +1. The time now is 07:17 AM.

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"