Tips & Tricks 146 – When I input a number, Excel automatically inserts a decimal with 2 decimal points

Sometimes, you might face a problem that you input a number say 567 and it automatically becomes 5.67. If you enter 8, it becomes 0.08.

To correct this problem > File > Options > Advanced and uncheck Red Zone