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

[Onitto]

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

 

[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

 

[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.