Excel changes number formatting

[faint]

Hello,

I'm using Excel 2003 and Windows XP SP2.

I am not using any special formulas and I have not altered any formatting.

I use a single workbook with about 25 worksheets in it.

Suddenly, when I enter a plain round number, Excel enters it as a decimal point.

Example: I enter a round number like 5 and it enters it as .05

I try to enter a round number again in the next row, same column and unless I enter a round number and a period, it enters the round number as a decimal point again.

I have to keep entering a period just to get my whole number to appear.

I tried to fix this by selecting the number format, the text format and even the general format, one at a time, and the same problem exists.

Some of the worksheets in this same workbook allow round numbers to be entered correctly and some don't.

This was from Excel 2003's help and this is what I've been using all along:

Number: This format is used for the general display of numbers. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.

I appreciate the help especially considering this would be the least of anyone's problems here!

 

[Norie]

Check the Edit tab under Tools>Options...

Is Fixed decimal checked perhaps?

 

[faint]

Yes, it is, Norie.

I don't know how that happened and I also did not know to look there. I knew this was going to be a stupid question, but it took me two months to get brave enough to post it!

You're a lifesaver. Now I can update my inventory sheets in peace!

Thank you very, very much!
Steph