how do i remove % from a colum how to remouve % 21.09.2006 12:04:01 i wanted a percntage in one box of a colum but now every box in that colum comes as a percentage how do i stop this i havetried hitting the % button again but to no avail please help its recking my head

RE: how do i remove % from a colum kassie 21.09.2006 12:28:04 You probable select the column before applying this format. To resolve, select the cells you do not want formatted as %, right click, select format cells, and format it as General, or as Number, or as whatever you want it to be "how to remouve %" wrote: [Quoted Text] > i wanted a percntage in one box of a colum but now every box in that colum > comes as a percentage how do i stop this i havetried hitting the % button > again but to no avail please help its recking my head >

Re: how do i remove % from a colum "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 21.09.2006 18:00:49 When you type, for example, 5%, 6%, and 7% in three cells (say A1:A3), Excel very kindly formats the rest column A as percent. So when you type 8 in A4 Excel makes it 8%. As Ang recommends, formatting the rest of the cells as General BEFORE you add new data will do the trick. If you do not like this behaviour, use Tools | Options and on the Edit tab unselect 'Enable automatic percent entry'. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "how to remouve %" <how to remouve %[ at ]discussions.microsoft.com> wrote in message news:182B3E27-3E69-48D1-9423-04BCE39E03B0[ at ]microsoft.com... [Quoted Text] >i wanted a percntage in one box of a colum but now every box in that colum > comes as a percentage how do i stop this i havetried hitting the % button > again but to no avail please help its recking my head >

Re: how do i remove % from a colum Gord Dibben <gorddibbATshawDOTca> 21.09.2006 18:44:16 I would uncheck the "entend data range formats and formulas" "Enable automatic percent entry" just changes the percentage formatting. Enable automatic percent entry........from help Select to multiply by 100 all numbers less than 1 that you enter in cells formatted in the Percentage format. Clear this check box to multiply by 100 all numbers that you enter in cells formatted in the Percentage format, including numbers equal to or greater than 1. Gord Dibben MS Excel MVP On Thu, 21 Sep 2006 15:00:49 -0300, "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> wrote: [Quoted Text] >When you type, for example, 5%, 6%, and 7% in three cells (say A1:A3), Excel >very kindly formats the rest column A as percent. So when you type 8 in A4 >Excel makes it 8%. As Ang recommends, formatting the rest of the cells as >General BEFORE you add new data will do the trick. >If you do not like this behaviour, use Tools | Options and on the Edit tab >unselect 'Enable automatic percent entry'. >best wishes

Re: how do i remove % from a colum "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 21.09.2006 18:51:30 Yes one could do that but the topic was % formatting -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:42n5h21ll4q96dukkcenfo41bgasj5mqqu[ at ]4ax.com... [Quoted Text] >I would uncheck the "entend data range formats and formulas" > > "Enable automatic percent entry" just changes the percentage formatting. > > Enable automatic percent entry........from help > > Select to multiply by 100 all numbers less than 1 that you enter in cells > formatted in the Percentage format. Clear this check box to multiply by > 100 all > numbers that you enter in cells formatted in the Percentage format, > including > numbers equal to or greater than 1. > > > Gord Dibben MS Excel MVP > > > On Thu, 21 Sep 2006 15:00:49 -0300, "Bernard Liengme" > <bliengme[ at ]stfx.TRUENORTH.ca> wrote: > >>When you type, for example, 5%, 6%, and 7% in three cells (say A1:A3), >>Excel >>very kindly formats the rest column A as percent. So when you type 8 in A4 >>Excel makes it 8%. As Ang recommends, formatting the rest of the cells as >>General BEFORE you add new data will do the trick. >>If you do not like this behaviour, use Tools | Options and on the Edit tab >>unselect 'Enable automatic percent entry'. >>best wishes >

Re: how do i remove % from a colum Gord Dibben <gorddibbATshawDOTca> 21.09.2006 19:53:12 The subject was % formatting, but the topic was stopping the % sign from showing as OP moved down the column. [Quoted Text] > i wanted a percntage in one box of a colum but now every box in that colum > comes as a percentage how do i stop this i havetried hitting the % button > again but to no avail please help its recking my head Gord On Thu, 21 Sep 2006 15:51:30 -0300, "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> wrote: >Yes one could do that but the topic was % formatting Gord Dibben MS Excel MVP

Re: how do i remove % from a colum "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 22.09.2006 00:21:03 You are correct - my apologies -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:e8r5h2561h32lhpqd0171vn7isps8in328[ at ]4ax.com... [Quoted Text] > The subject was % formatting, but the topic was stopping the % sign from > showing > as OP moved down the column. > >> i wanted a percntage in one box of a colum but now every box in that >> colum >> comes as a percentage how do i stop this i havetried hitting the % button >> again but to no avail please help its recking my head > > Gord > > On Thu, 21 Sep 2006 15:51:30 -0300, "Bernard Liengme" > <bliengme[ at ]stfx.TRUENORTH.ca> wrote: > >>Yes one could do that but the topic was % formatting > > Gord Dibben MS Excel MVP

Re: how do i remove % from a colum Gord Dibben <gorddibbATshawDOTca> 22.09.2006 03:23:19 From you Bernard, not necessary. Just trying get it all straight in my mind, which is difficult sometimes<g> Gord On Thu, 21 Sep 2006 21:21:03 -0300, "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> wrote: [Quoted Text] >You are correct - my apologies Gord Dibben MS Excel MVP