View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Put 2 in an empty cell
copy that cell
select your range
edit|paste special|multiply

clean up that 2 in that cell.

Robert wrote:

In excel I have four columns all containing 500 cells. These cells represent
wholsale pricing. I want to muliply each column by 2 so they represent
retail pricing.

Robert


--

Dave Peterson