Use edit/replace 1.2 with 1.5

--
Don Guillett
SalesAid Software

"Michal" wrote in message
...
Well OK, but I would like to have pasted the A1 cell instead of 1.2 value
into selected cells, so if I change the A1 value from 1.2 to 1.5 all
selected
cells will be multiplied by this factor.

"Anne Troy" wrote:

Copy a cell that contains the value 1.2. Now select all the cells you
want
to increase. Hit Edit--Paste special, Multiply.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Michal" wrote in message
...
I have a table with quarters in rows and values in columns. I need to
increase all values by some factor (lets say number in cell A1). I
know
that
I can multiply every cell separatelly. Is there any other, more
automatic
way?