View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Applying a discount to a column of prices!

In another cell, type .9
Copy that cell

Then select the column of numbers
EditPasteSpecialMultiply
OK

Go back and clear the cell.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JK" wrote in message
...
I have a column of prices around 300 entries.

Being lazy I would like to know how I can apply a formula to reduce
each price by 10%.

There is no other calculation in that column.