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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"joesther37" wrote
in message ...

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.



--
joesther37
------------------------------------------------------------------------
joesther37's Profile:
http://www.excelforum.com/member.php...o&userid=30031
View this thread: http://www.excelforum.com/showthread...hreadid=497180