Dec 13, 2011, 07:16 AM
I have a column with numbers. I need to multiply the same numbers with 3 and I don't want to make a new column - it must happen in the same one. Is there any function for that?

kcomissiong
Dec 13, 2011, 07:27 AM
Can you give a little more info? Do you want to multiply all the munbers in the column or just some of them? You can write a formula for the cell you want the total to apper in. For instance, you can write a formula into a cell like =B8*B12 and that cell will equal the product of the new cell. Please let me know if this covers what you are trying to do.

JBeaucaire
Dec 13, 2011, 04:50 PM

1) In an empty cell, put in your multiplier, in this case the number 3
2) Now copy that cell
3) Highlight all the numbers in your original column all at once
4) Now select Edit > Paste Special > Multiply > OK

Dec 14, 2011, 03:02 AM
I need to multiply all the numbers in the column.

ScottGem
Dec 14, 2011, 03:41 AM
I need to multiply all the numbers in the column.

So did you try what JB suggested?