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

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
 
P

PJ

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To make pdf to work as word 1
Header Roman Numeral to Regular Numbers 1
Autonumber field in Excel that behaves the same as Access 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Format a Range to Multiply by 1000 5
Update several ppt documents from a single excel file 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
how can I multiply a column by only one cell? 4

Top