Why do the general and number cell formats not work correctly?

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

Guest

In my new Excel 2003, the "general" cell format erroneously inserts a decimal
and a zero in front of the typed whole number. And the "number" cell format
(with zero decimal places checked) erroneously substitutes a single zero for
whatever whole number was typed. This happens every time. My old Excel
version worked perfectly in these two cases. What am I missing?
 
Hi Frank, go to your Tools > Options > Edit tab and
uncheck "Fixed Decimal Places" that should fix you up.

HTH
Kevin M
 

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

Decimal point in general format 1
Change number format if value is zero 1
Problem entering numbers 3
Conditional formatting a cell containing "<" 4
problem with number format with 2 decimals? 5
Conditional formatting & decimal part of a number in cell 2
How can I keep a zero (0) at the front of a set of numbers. 2
Trim varying decimals from column of numbers 9

Back
Top