 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006how do i remove % from a colum
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 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 > 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 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  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email >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 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 >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 [quoted text clipped - 3 lines] >unselect 'Enable automatic percent entry'. >best wishes Yes one could do that but the topic was % formatting SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email >I would uncheck the "entend data range formats and formulas" > [quoted text clipped - 19 lines] >>unselect 'Enable automatic percent entry'. >>best wishes 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 >Yes one could do that but the topic was % formatting Gord Dibben MS Excel MVP You are correct - my apologies SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > The subject was % formatting, but the topic was stopping the % sign from > showing [quoted text clipped - 10 lines] > > Gord Dibben MS Excel MVP From you Bernard, not necessary. Just trying get it all straight in my mind, which is difficult sometimes<g> Gord >You are correct - my apologies Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.