Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
Numbers are entered with the wrong number of decimal places
Posted by - NA - on 21 March 2006 07:31 AM
|
|
|
Solution: For example, entering 154 appears as 1.54 in the cell. Somehow Excel's fixed-decimal mode was turned on. To return to normal: 1.Select Tools - Options to display the Options dialog box. 2.Click the Edit tab 3.Remove the checkmark from the Fixed decimal option. Of course, this feature can be useful when entering some types of data, but most of the time, you'll want to keep the fixed-decimal mode turned off. | |
 (130 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)