Entered Values are Divided by 100


Here are a few different things that could be causing the problem. The most likely is that Excel is configured so it automatically places a decimal point in your entry. You can tell if this is the case by looking at the status bar; if it has the words “Fixed Decimal” appear there, then this is the cause.

Turn it off by following these steps if you are using Excel 2007:


Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.


At the left of the dialog box click Advanced.


Under Editing Options, make sure that the check box for “Automatically Insert a Decimal Point” is cleared. (See Figure 1.)


Screenshot // Entered Values are Divided by 100
Entered Values are Divided by 100

One thought on “Entered Values are Divided by 100

  1. “Hello:
    Thank you for your information, I found it very useful. There is small error in this formula. “”Worksheet function that returns the workbook name:””
    The corrected one should read as follow =MID(CELL(“”filename””),FIND(“”["",CELL(""filename""))+1,FIND(""]“”,CELL(“”filename””))-FIND(“”[“”,CELL(“”filename””))-1) “

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>