Under Editing Options, make sure that the check box for "Automatically Insert a Decimal Point" is cleared.At the left of the dialog box click Advanced.In Excel 2010 and later versions display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. 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. The most likely is that Excel is configured so it automatically places a decimal point in your entry. There are a few different things that could be causing the problem. He wonders why the value is being divided by 100. Christopher noted that if he enters 1 into a cell, Excel automatically converts it to.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |