View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Help needed in a simple task

Stick 2 in an unused cell.
select that cell
edit|copy
select your range to adjust

Edit|paste special|check Multiply

clean up that helper cell with the 2 in it.

vmantrana wrote:

Hi , IŽd 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


--

Dave Peterson