Help! How do I multiply all selkected cells by 10%?

K

Ken

Looking to select a block of cell, an dmultiply them all by a given
percentage (10%).
Then, I'd like to replace the old cell values with these new higher values.
Thanks!
- Ken
 
F

Frank Kabel

Hi
try the following:
- enter 0.1 in an empty cell and copy this cell (or if you want to
increase the values by 10% enter 1.1)
- select your 'old' data
- goto 'Edit - Paste Special' and choose 'Multiply'
 
J

Juan Pablo González

Put

1.1 (or 110%) in an empty cell
Copy it

Select the cells that you want to change

Go to Edit | Paste Special

Select "Values" and "Multiply"

Click OK.
 
D

duane

type 1.1 in a cell somewhere
select copy
select all the cells you want to multiply paste special, multipl
 
Top