excel formulas

[Brian B]

I am trying to multiply a row of cells by the same number without making an
additional row with the results. For example:
10
10
10
10
10

All multilplied by3%, thus displaying:
..03
..03
..03
..03
..03

Any way to make this happen without creating an additional row? Can I keep
the original data part of the formula?

Hope this makes sense...THX!

 

[Duke Carey]

put .03 in an empty cell
Copy the cell
Select the cells you want to multiply
Use Edit-Paste Special - Multiply

 

[Pete_UK]

You can do it in one operation, but this will permanently change the
value in those cells as it does not use a formula.

Choose a blank cell somewhere and enter 3% (or 0.03) into the cell.
Select the cell again and click <copy>. Then move the cursor to
highlight the cells you want to change, then click Edit | Paste
Special | Multiply (check) | OK then <Esc>.

Then you can delete the contents of the original cell.

Hope this helps.

Pete

 

[Bernard Liengme]

In some blank cell enter 0.03 (or 3%, as you like)
Copy this cell
Select the row (or column) of numbers to be fixed
Use Edit | Paste Special and put a check in the Multiply box
Now you can delete the 3% in the first cell
best wishes

 

[T. Valko]

Try this...

Enter 0.03 in a cell
Copy that cell: Edit>Copy
Select the range of numbers you want to change
Then: Edit>Paste Special>Multiply>OK
Delete the 0.03

 

[Brian B]

Duke, thanks much!

BB

put .03 in an empty cell
Copy the cell
Select the cells you want to multiply
Use Edit-Paste Special - Multiply

 

[David Biddulph]

A number of other users have told you about Paste Special/ Multiply, but of
course if you multiply 10 by 3% you will get 0.3, not 0.03.