Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to multiply ALL numeric cells in a sheet by same number ?
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I MULTIPLY BY A VALUE NOT MORE THAN A CERTAIN NUMBER | Excel Discussion (Misc queries) | |||
Need Help Creating a Macro to Multiply Cells by a Constant Number | Excel Discussion (Misc queries) | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
How do I Multiply different cells by one number as a formula? | New Users to Excel | |||
How do I multiply the whole sheet by a number | Excel Discussion (Misc queries) |