Put 2 in a cell and Copy
Select the range you want multiplied, and Paste Special, Values +
Multiply

HTH

--

vmantrana Wrote:
Hi , I=B4d like to know how to solve the following problem, I have a
column of numbers and I want to multiply each number in the column by
a constant, for example 2. And get the result in the same place as the
previous numbers.

Thanks for your help


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533593