Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 28th 09, 02:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 298
Default 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   Report Post  
Old August 28th 09, 03:15 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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 right-click 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   Report Post  
Old August 28th 09, 03:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
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?


  #4   Report Post  
Old August 28th 09, 03:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 298
Default 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 right-click 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   Report Post  
Old August 28th 09, 05:30 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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 right-click 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Divide within the same cell RJ Swain Excel Discussion (Misc queries) 2 February 20th 08 02: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 07:13 PM
I need to know if there is a way to divide a cell kdwwattn Excel Discussion (Misc queries) 1 January 3rd 05 11:35 PM


All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017