Need help applying a formula to a certain area of the worksheet

[pirouz]

I am trying to multiply a value to a set of current data on a wor
sheet. The value is 0.7 and the range of cells is B4:N33 for example.
Can anyone help me with this??

Thanks-
Pirou

 

[Bob Phillips]

Enter 1.07 in an unused cell. Copy that cell

Select B4:N33
Goto Edit>PasteSpecial
Click Multiply
OK

Clear the 1.07 from the cell.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[pirouz]

Thank you very much!