Applying a discount to a column of prices!
 

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.

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.

Applying a discount to a column of prices!
 

Many thanks, easy to do, hard to find when I tried to work it ou.
Very grateful

JK


On Wed, 4 Jan 2006 11:47:22 +0000 (UTC), JK wrote:

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.