View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Help with fixed decimal

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