how to multiply all entries in an excel column by a number [closed]

Question

I have an excel sheet with huge column size. I want to operate upon the column (no copying to a blank column) and multiply all the entries in that column by 1000, replacing the previous entries. Any help is appreciated. Thanks.

Answer 1

Here is the solution for you.

All you need to do is write a value in a cell, copy that and then use paste special option.

How to multiply a range cells by a number in Excel?

Answer 2

you can put the number that you need to multiply for in an other cell, for example in the image is B1, then create an other column multiplying the first number (image is A2) by the one in B1, but put the formula with $B$1 instead of B1, that will keep B1 value static, then drag the formula down and that is it, a new column with all entries multiplied by B1.