HI Jim.

Could you help me. I have a similar problem to the one you answered below
some time ago. Searched the web for answers you see.

I have a column of values say from b3:b23 and I need to reduce these by 15%.
Is there anyway I can get a formula that just updates the values all at the
same time without using another column to show the values in. I tried to use
the formula you gave below and I can update each cell using the formaula for
example =b3*1.15 but that would be cumbersome to do that for over a hundred
values. Unfortuantely for some reason I to dont have the multiply option when
you go to paste special etc. It simply gives the option of pasting either in
text or unicode.

Any help

"Jim Cone" wrote:


Enter 1.1 in a blank cell.
Copy the cell.
Select the column of prices.
Go to... Edit (menu) | Paste Special | Multiply (button) - click Ok.
Press the Escape key.
Delete 1.1 in the blank cell.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Tom McLean"
wrote in message
Is it possible to update or change the values in a range of cells by a
certain percentage? What I'm trying to do is apply a 10% increase to a column
of prices (several hundred cells long) without doing it manually one by one
or creating a new column (B) that references the values in the first column
(A) and then manipulates the values by X%.

Basically, I'm supposed to update the price list without changing it's
present format. I expect to need to do this again in the future several times
and it would be wonderful if there was some way to do it quickly and easily.

Thanks for any ideas!!
Tom