Whenever I enter a figure in Excel it divides it by 100....

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: comp.apps.spreadsheets FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Hobo
Submitted on 1/20/2004
Related FAQ: comp.apps.spreadsheets FAQ
Rating:	Rate this question:
Whenever I enter a figure in Excel it divides it by 100. Cell format etc seems fine. What am I doing? It suddenly started to happen and must be something basic but I am lost for answer.

Answer by Quaiser
Submitted on 2/7/2005
Rating: Not yet rated	Rate this answer:
In the Tools - Options dialog box... On the Edit Tab... If you have "Fixed Decimal Places" checked, it automatically divides any number. If you automatic decimal place is set to 2, it divides by 100; if set to 3, it divides by 1000 and so on...

Answer by mereaves
Submitted on 1/24/2006
Rating: Not yet rated	Rate this answer:
Go to the following steps: 1. CLICK on TOOLS menu 2. CLICK on OPTIONS... item 3. CLICK on EDIT tab (where you see view, calculation, edit, general, etc.) 4. LOOK to see if "Fixed Decimal" has a check next to it. If so, take it off. 5. CLICK "OK" button. On a quick check, this is the only thing I could find that would cause this problem.

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: