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.

In another cell, type .9
Copy that cell

Then select the column of numbers
Edit>PasteSpecial>Multiply
OK

Go back and clear the cell.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JK" <nospam@nospam.com> wrote in message
news:avcnr1ttnmsuve874es88r3hr7saqf68mf@4ax.com...
> 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.

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 <nospam@nospam.com> 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.