Remember Me?

#1
August 28th 09, 02:34 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 298
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
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
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
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
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
August 28th 09, 03:24 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 298
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
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
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 -

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post RJ Swain Excel Discussion (Misc queries) 2 February 20th 08 03:31 AM Ali.Abughrabieh[_2_] Excel Discussion (Misc queries) 0 August 17th 07 02:03 AM CLR Excel Discussion (Misc queries) 0 August 17th 07 01:58 AM Rick Excel Discussion (Misc queries) 0 March 4th 05 08:13 PM kdwwattn Excel Discussion (Misc queries) 1 January 4th 05 12:35 AM

All times are GMT +1. The time now is 09:16 PM.