Microsoft Excel Question:
When I enter a value, it appears with two decimal places. For example, when I enter 154 it shows up as 1.54. Whats wrong?
Answer:
Somehow Excel's fixed-decimal mode was turned on. To return to normal, select Tools, Options to display the Options dialog box. Then click the Edit tab and remove the check mark 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.
| Previous Question | Next Question |
| Can I change the color of the worksheet tabs in my workbook? | I am converting from Quatro Pro to Excel. What happened to my cell comments? |