Steve,

That is indeed how it is supposed to work, and how it actually works for me.

Do you have any event code that would change the entry value? A lot of folks use the change event to
handle decimal points.

HTH,
Bernie
MS Excel MVP


"Steve" wrote in message
...
I am using and learning Excel 2003. I checked fixed decimals and checked two
decimals in the options box of the tools menu. The fix word then appears in
the lower right hand corner of the screen. The following is my problem: I was
taught that by putting a period after a whole number and hitting enter the
number will be added to the cell as a whole number and not with a two decimal
entry. Example being...input 1009. into a cell and then press enter. The
result in the cell should be 1009 but I keep getting 10.09 . I thought that
by putting the period after the whole number indicates that the entry will be
the whole number and not a decimal entry. Any help would be greatly
appreciated. Thanks, Steve