View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Help with fixed decimal

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

"David Biddulph" wrote:

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?
--
David Biddulph

"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