Two Steps:

1. Tools Options Edit and clear the fixed decimal places checkbox
2. Format Cells... Number General
--
Gary's Student


"Pepperpixie" wrote:

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?