Cannot enter numbers in Excel 2003
 

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?

Cannot enter numbers in Excel 2003
 

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?