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!