View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
PJ PJ is offline
external usenet poster
 
Posts: 112
Default How to multiply ALL numeric cells in a sheet by same number ?

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.

"MoiMeme" wrote:

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