 |
 | 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 / Setup / August 2008Number entered in cell getting always divided by 100 !
I use excel 2007. Whenever i enter a number in cell, it gets divided by 100. For example, when i enter 10, it displays as 0.01. How to resolve this problem ? really frustrated with this error ! DKL Office button (large, round, top left corner)>Excel Options>Advanced tab, uncheck Automatically insert a decimal point  SignatureKind regards, Niek Otten Microsoft MVP - Excel |I use excel 2007. Whenever i enter a number in cell, it gets divided by 100. | For example, when i enter 10, it displays as 0.01. | | How to resolve this problem ? really frustrated with this error ! | DKL I am using Excel 2003 with same problem. There is no Office button. How do I get the entries not to be divided by ten? Joe G > Office button (large, round, top left corner)>Excel Options>Advanced tab, uncheck Automatically insert a decimal point > [quoted text clipped - 3 lines] > | How to resolve this problem ? really frustrated with this error ! > | DKL Tools>Options>Edit tab, uncheck Fixed decimal SignatureKind regards, Niek Otten Microsoft MVP - Excel |I am using Excel 2003 with same problem. There is no Office button. How do | I get the entries not to be divided by ten? [quoted text clipped - 7 lines] | > | How to resolve this problem ? really frustrated with this error ! | > | DKL Hi Niek, Please help me in Office 2008 for Mac. There is the same problem, all numbers are divide by 100. But in the Mac the menu is different like in Windows. Can you help me? Thanks. > Office button (large, round, top left corner)>Excel Options>Advanced tab, uncheck Automatically insert a decimal point > [quoted text clipped - 3 lines] > | How to resolve this problem ? really frustrated with this error ! > | DKL Hi Rodrigo, Preferences -> Edit -> Uncheck Display this number of decimal places. That is it. > Hi Niek, > [quoted text clipped - 12 lines] > > | How to resolve this problem ? really frustrated with this error ! > > | DKL |
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.