 |
 | 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 / July 2006Typing "12345" and have it automaticly formated to "123.45"?
Does anyone know anything about formatting cells so they would behave like an accounting calculator. As in typing "12345" without pressing any decimal key, and have it use the last two digits as the tenth and hundredth decimal place, ie) "123.45"? If it isn't possible, it would be informative to know that as well. Thanks a million in advance!  SignatureZenTrickz Go to the Tools menu, choose Options, then the Edit tab. There, check the Fixed Decimals setting and choose the number of decimal places you want (default is 2). SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ZenTrickz" > > Does anyone know anything about formatting cells so they would [quoted text clipped - 9 lines] > > Thanks a million in advance! I should have added that this changes the actual value of the cell, not just the displayed value. SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com > Go to the Tools menu, choose Options, then the Edit tab. There, > check the Fixed Decimals setting and choose the number of [quoted text clipped - 12 lines] >> >> Thanks a million in advance! Try this: From the Excel main menu <tools><options><edit tab> Check: Fixed decimal Set Places to 2 Does that help? Regards, Ro Thanks Chip! Thanks Ron! Today you guys are my hero : In any future cases, you might keep in mind that you can simply change the formatting of the 'problem' cell. By right-clicking selecting Format Cell, you can ensure that the cell you selected isn't set as a date, currency, decimal, so on and so forth. Just FYI! Glad they resolved the issue for you! |
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.