EXCEL VBA Questions and Answers

Your colleague created a dashboard and when you enter a value, it appears with two decimal places. For example, when you enter 265 it shows up as 2.65. What’s wrong?

By chance Excel’s fixed-decimal mode was turned on. To return to normal,
Excel 2003 –>
Click Tools and then Options to display the Options dialog box.
Then click the Edit tab and remove the check mark from the “Fixed decimal ” option.
Excel 2007 –>
Click Office button on Top-Left corner and click ‘Excel Options’.
Go to Advanced and Uncheck ‘Automatically insert a decimal point’ option.
Excel 2010 –>
Click File button on Top-Left corner and click ‘Excel Options’.
Go to Advanced and Uncheck ‘Automatically insert a decimal point’ 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.