Help with fixed decimal

[Steve]

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

 

[Bernie Deitrick]

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

 

[David Biddulph]

Yes. Decimal point after the number should (and does for me) over-ride the
fixed decimals. Do you have a macro or an auto-correction option that is
upsetting things? Do your regional settings look for a period or for a
comma as the decimal point?

 

[Steve]

Bernie,
Thanks for the quick response. Not sure what you mean by an event code. I
haven't changed anything else on my computer or the Excel program. It seems
that the fixed decimal function is not recognizing the period that I place
after the whole number.
Steve

 

[Steve]

David,
Thanks for the reply. How would I know if I have a Macro or auto-correct
option that might be doing this? I tried inputing the number 1009 with a
comma after it and it entered it into the cell as "1009," left hand
registered. For some reason it is not recognizing the period I place after
the whole number.
Steve