O Onitto Jun 2, 2010 #1 I want to change table values by a factor of 1/100. So that values become fractions from percentages. 99 to 0.99.
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 Jun 2, 2010 #2 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
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 Jun 2, 2010 #3 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.
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.