Change the values of cells by a fixed factor i.e. 10/100= 0.10

O

Onitto

I want to change table values by a factor of 1/100. So that values become
fractions from percentages. 99 to 0.99.
 
G

Gord Dibben

Enter 100 in an unused cell.

Copy that cell.

Select the range to change and Paste Special>Divide>OK>Esc.

Delete the cell with 100.


Gord Dibben MS Excel MVP
 
G

Gary''s Student

Say we want to reduce the value in cells by 1%
So 100 would become 99

In an unused cell, enter .99
Copy this cell
Paste/Special/Multiply onto the cells you want to reduce.
 
Top