| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the values of cells by a fixed factor i.e. 10/100= 0.10
I want to change table values by a factor of 1/100. So that values become
fractions from percentages. 99 to 0.99. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change the values of cells by a fixed factor i.e. 10/100= 0.10
Enter 100 in an unused cell.
Copy that cell. Select the range to change and Paste SpecialDivideOKEsc. Delete the cell with 100. Gord Dibben MS Excel MVP On Wed, 2 Jun 2010 07:29:01 -0700, 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change the values of cells by a fixed factor i.e. 10/100= 0.10
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format change when user select a Factor on drop down box | Excel Worksheet Functions | |||
| How to multiply all cells in array by factor | Excel Discussion (Misc queries) | |||
| multiply all values in all cells by a factor | Excel Discussion (Misc queries) | |||
| Formula to sum various cells based on rate factor | Excel Worksheet Functions | |||
| change operating cells dynamically according to the value of a fixed cell | Excel Worksheet Functions | |||
Linear Mode
