View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Formatting a cell to divide by 12

if you want the value to equal 1/12th of what it used to, simply put =12
in a spare cell, copy that cell, then select the other cells and use
Paste Special, and select Operation, Divide

Rich wrote:

I have multiple cells with a value of X.
I want to divide X by 12.
Other than going thru and adding = and /12 to every cell, is there a way to
select all cells, and then format to /12?