Whenever I try to type in a number in a cell it shows only 0 (zero), however
in the formula field it shows the number I just typed in. I checked the cell
format and everything looks correct:
Category: Number
Decimal places: 2
Use 1000 separator is checked.
But in the "sample" area it still shows 0.

Is there anyway to run excel and set it back to default options?