 |
 | 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 / March 2008cell format
When I enter a whole number (i.e. - 1, 2) into a cell, the result is a percentage (i.e. - .01, .02). I have reset the format to number, with no success. Tools > Options > Edit > clear the fixed decimal checkbox  SignatureGary''s Student - gsnu200773 Sounds like you have got Fixed Decimals turned on - this lets you type 12345 and get 123.56 (for lazy bookkeepers) Use Tools | Options; open the Edit tab; uncheck the Fixed Decimal option box best wished SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email > When I enter a whole number (i.e. - 1, 2) into a cell, the result is a > percentage (i.e. - .01, .02). I have reset the format to number, with no > success.
|
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.