Entire row * 3%

[anakaine]

This is probably an easy question, I'm just struggling with...

I have a column of values beginning at column I row 2 that will periodically need to be multiplied by 3% (ie 1.03).

From row two, until the bottom of the column, where there is no more data.

How would I go about this?

The worksheet name is "myprodlist"
I am using Excel 2003 on Win XP SP2



Any help is greatly appreciated
Thankyou

 

[Scott Huish]

Put 1.03 in an empty cell.
Copy this cell.
Select your range to multiply.
Click on Edit, then Paste Special
Select Multiply
Click OK.

 

[anakaine]

Thankyou very much. Did the job