How do I multipy a range of cells by a common number?

K

Kevin H. Stecyk

Hi Art,

Enter your number in the spreadsheet in a blank cell. Copy. Edit | Paste
Special...multiply.

HTH.

Kevin
 
G

Gord Dibben

In future please type your problem and requested solution in the body of your
posting.


Enter a number in an unused cell.

Copy that cell.

Select your range of data and Paste Special>Multiply>OK>Esc.

Delete the cell with the nunber.


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 09:55:08 -0800, Art <[email protected]> wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I change number format from 3,999.89 to 399989 0
numbers need to be numbers 4
Linking data in MS Word into Excel 5
Refresh - F2 1
Multiple IF conditions 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Changing a cell colour if target not met. 4
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Top