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
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"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) "