software

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
Editgt;PasteSpecialgt;Multiply
OK

Go back and clear the cell.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JKquot; gt; wrote in message
...
gt; I have a column of prices around 300 entries.
gt;
gt; Being lazy I would like to know how I can apply a formula to reduce
gt; each price by 10%.
gt;
gt; 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

JKOn Wed, 4 Jan 2006 11:47:22 0000 (UTC), JK gt; wrote:

gt;I have a column of prices around 300 entries.
gt;
gt;Being lazy I would like to know how I can apply a formula to reduce
gt;each price by 10%.
gt;
gt;There is no other calculation in that column.