Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
When I enter 123 in a cell, it appears in the cell as 1.23. What's going on?
Posted by - NA - on 28 March 2006 03:20 AM
|
|
|
Solution: You've got the "Fixed Decimal" option turned on. Go into Tools->Options->Edit and uncheck the Fixed Decimal option. This feature is intended to allow you to enter dollar-and-cents amounts without having to enter the decimal point. | |
 (151 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)