excel formulas
 

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!

excel formulas
 

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


"Brian B" wrote:

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!

excel formulas
 

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

On Oct 1, 7:15*pm, Brian B wrote:
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!

excel formulas
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brian B" wrote in message
...
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!

excel formulas
 

Try this...

Enter 0.03 in a cell
Copy that cell: EditCopy
Select the range of numbers you want to change
Then: EditPaste SpecialMultiplyOK
Delete the 0.03

--
Biff
Microsoft Excel MVP


"Brian B" wrote in message
...
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!

excel formulas
 

Duke, thanks much!

BB

"Duke Carey" wrote:

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


"Brian B" wrote:

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!

excel formulas
 

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.
--
David Biddulph

"Brian B" wrote in message
...
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!