Cannot enter numbers in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Two Steps:

1. Tools > Options > Edit and clear the fixed decimal places checkbox
2. Format > Cells... > Number > General
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Decimal Place goes crazy when using the "&" Sign. 4
Default number format in Excel 1
Why is Excel calculating a number? 2
Red cell for negative numbers in Excel 1
Numbers showing Up Centered in Cell ? 1
how to show numbers that begin with 0 in excel 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1

Back
Top