Thread: Change the values of cells by a fixed factor i.e. 10/100= 0.10
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote