entering 2211. still displays 22.11 instead of 2211.00

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

Guest

I have cells fixed to two decimal places and when I enter 2211. (period) it
displays 22.11 as though the decimal I keyed in doesn't matter. This worked
fine in excel 2002, but now in excel 2003 it ignores the decimal keyed in.
Any help here
 
Hi

Go to Tools|Options|Edit and have a look at the Fixed Decimal option.
Uncheck it if necessary.
Hope this helps.
 
Bob

This is "new feature" in Excel 2003.

To override the fixed decimals you must enter 2211.0 instead of the previous
versions' 2211.


Gord Dibben Excel MVP
 
Gord Dibben wrote:
|| Bob
||
|| This is "new feature" in Excel 2003.
||
|| To override the fixed decimals you must enter 2211.0 instead of the
|| previous versions' 2211.
||
||

Well my Excel 2003 doesn't show this behaviour. If I enter 2211 into a cell
formatted for 2 fixed decimal places, the cell shows 2211.00 NOT 22.11
 
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

Automaticallychanging the number of decimal places displayed 5
Help with fixed decimal 4
Fixed decimal places in Excel 4
Losing cell formatting as a result of a mail merge 5
Cell displays #'s incorrectly 3
Excel Stop Excel from displaying rounded values 4
Entering data 1
Fixed decimals 1

Back
Top