Prev: Conditional Formatting by percent range
Next: Conditional Formatting, Date Ranges and Rows
From: Onitto on 2 Jun 2010 10:29
I want to change table values by a factor of 1/100. So that values become
fractions from percentages. 99 to 0.99.
From: Gord Dibben on 2 Jun 2010 10:37
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

On Wed, 2 Jun 2010 07:29:01 -0700, Onitto <Onitto(a)discussions.microsoft.com>
wrote:

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

From: Gary''s Student on 2 Jun 2010 10:40
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.
--
Gary''s Student - gsnu201003


"Onitto" wrote:

> I want to change table values by a factor of 1/100. So that values become
> fractions from percentages. 99 to 0.99.
 | 
Pages: 1
Prev: Conditional Formatting by percent range
Next: Conditional Formatting, Date Ranges and Rows