| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ...?) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Whole number converts to decimal | Excel Discussion (Misc queries) | |||
| My numbers format as a number with two decimal places. | Excel Discussion (Misc queries) | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
| How do I insert 2 decimal places to a number in cell? | Excel Worksheet Functions | |||
| Fixing a decimal point | Excel Discussion (Misc queries) | |||
Hybrid Mode
