If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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? 
Ads 
#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  
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Divide within the same cell  RJ Swain  Excel Discussion (Misc queries)  2  February 20th 08 03:31 AM 
divide the cell  Ali.Abughrabieh[_2_]  Excel Discussion (Misc queries)  0  August 17th 07 02:03 AM 
divide the cell  CLR  Excel Discussion (Misc queries)  0  August 17th 07 01:58 AM 
Divide one row over other row I dont wont to divide one number  Rick  Excel Discussion (Misc queries)  0  March 4th 05 08:13 PM 
I need to know if there is a way to divide a cell  kdwwattn  Excel Discussion (Misc queries)  1  January 4th 05 12:35 AM 