View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Paul (Bornival)
 
Posts: n/a
Default position of decimal point when entering a number ...

Dear Ron,
Thank you. This solved all problems.
Have a nice week-end !
Paul.

"Ron Coderre" wrote:

Try this:
ToolsOptonsEdit tab
Uncheck: Fixed Decimal places

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Paul (Bornival)" wrote:

When I enter a number, the decimal point automatically poistions it-self
before the two last digits, even if I do *not* enter the decimal point.
Thus, if I enter 123, I get 1.23, etc...
When looking at the format of the cell, I see
- general
- sample: 1.23
How do I change this ?
(This was not occuring when Excel was installed, and is not occuring with
the same version of Excel on other machines; I suspect it ahs to do with a
corrupted temmlate, but which one ...?)