How to multiply ALL numeric cells in a sheet by same number ?

  • Thread starter Thread starter MoiMeme
  • Start date Start date
M

MoiMeme

Hi,

I have a sheet, where all numerical values have to be multiplied by a
conversion factor of 1.250

How can I achieve this ?

Thanks

Pivert
 
Hi

Enter your conversion factor in an empty cell, copy it and select the cells
you want to convert. Then right click, choose Paste Special..., under
Operation select Multiply, and OK.

By the way, I'm still using Excel 2003 but I guess it's much the same in 2007.
 
Back
Top