Home 
Search 
Today's Posts 
#1




Formatting a cell to divide by 12
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? 
#2




Formatting a cell to divide by 12
Is X the same in each of those cells, and you want to change that to X/
12 ? If so, then you could use Find & Replace. Or, do you mean that you want all the values in those cells (which are different) to be divided by 12? If so, you could put 12 in a blank cell somewhere, and <copy that cell. Then highlight all the cells that you want to change and rightclick then Paste Special  Values (check)  Divide (check) then OK and <Esc. Then you can delete the 12 from the original cell. Hope this helps. Pete On Aug 28, 2:34*pm, 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? 
#3




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? 
#4




Formatting a cell to divide by 12
The second suggestion was what I needed.
Thanks for the help. "Pete_UK" wrote: Is X the same in each of those cells, and you want to change that to X/ 12 ? If so, then you could use Find & Replace. Or, do you mean that you want all the values in those cells (which are different) to be divided by 12? If so, you could put 12 in a blank cell somewhere, and <copy that cell. Then highlight all the cells that you want to change and rightclick then Paste Special  Values (check)  Divide (check) then OK and <Esc. Then you can delete the 12 from the original cell. Hope this helps. Pete On Aug 28, 2:34 pm, 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? 
#5




Formatting a cell to divide by 12
You're welcome, Rich  thanks for feeding back.
Pete On Aug 28, 3:24*pm, Rich wrote: The second suggestion was what I needed. Thanks for the help. "Pete_UK" wrote: Is X the same in each of those cells, and you want to change that to X/ 12 ? If so, then you could use Find & Replace. Or, do you mean that you want all the values in those cells (which are different) to be divided by 12? If so, you could put 12 in a blank cell somewhere, and <copy that cell. Then highlight all the cells that you want to change and rightclick then Paste Special  Values (check)  Divide (check) then OK and <Esc. Then you can delete the 12 from the original cell. Hope this helps. Pete On Aug 28, 2:34 pm, 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? Hide quoted text   Show quoted text  
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Divide within the same cell  Excel Discussion (Misc queries)  
divide the cell  Excel Discussion (Misc queries)  
divide the cell  Excel Discussion (Misc queries)  
Divide one row over other row I dont wont to divide one number  Excel Discussion (Misc queries)  
I need to know if there is a way to divide a cell  Excel Discussion (Misc queries) 