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.

 Formatting a cell to divide by 12
 Author Name Remember Me? Password
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Formatting a cell to divide by 12

 Thread Tools Display Modes
#1
August 28th 09, 02:34 PM posted to microsoft.public.excel.misc
 Rich external usenet poster 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?
 Ads
#2
August 28th 09, 03:15 PM posted to microsoft.public.excel.misc
 Pete_UK external usenet poster 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
 Bob I external usenet poster 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
 Rich external usenet poster 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
 Pete_UK external usenet poster 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 -

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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:53 AM.

 - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top

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