Multiplying A Whole Column By 2 ??? Help

[joesther37]

Hello,

I recieve product stock list from my supplier in excell.
2 columns, A = products , B = prices
I need a formula that will multiply all prices in column B by 2
so I can then easily forward stock list to my customers without
revealing original values in column b.
I have tried all the basic first thought ideas and none have worked.
please provide help. thank you.
(e-mail address removed)

 

[Bernard Liengme]

Save the file first (this one is for you)
Now type 2 in any empty cell and copy it
Select all the B cell and use Edit |Paste Special->Multiply
All B values are now doubled!
Save file with another name (this one is for customers)
Happy New Year

 

[Cutter]

You can type the number 2 in any empty cell
Then copy that cell
Now select all the cells in column B that you want to double
Now right click on any cell in that selection and choose Paste Special
Choose Multiply and then O

 

[Guest]

This is a very simple one.

The formula you want is

=B1*2
if your putting this is C1

If you have a 'header row then use
=B2*2
(This would go in C2)

There's a great method of filling the rest of the cells you need with this
formula

Select cell C2 and click on the black square in the lower right hand corner.
This will fill the values down the entire list.

Now if you don't want your customers to know the orignal prices then put the
'final' product in a different workbook.

Start a new workbook and then click on column A hold CTRL and click column C
then paste these into your new worksheet. You'll have to delete column B in
your final workbook and send it off!!

That should take care of it!

(e-mail address removed)

 

[Guest]

Much better way of doing it than what I suggested.

I didn't realize that's how that feature worked!

Thanks for sharing!!!

(e-mail address removed)

 

[Ragdyer]

To make things a little easier and quicker, it pays to format the cell
containing the "2", *exactly* as you would like the column you're
incrementing to look like.
For example ... 2 decimals with a dollar sign.

That way, when you "Paste Special" and multiply, the entire column will end
up with the proper formatting.