Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
position of decimal point when entering a number ...
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 ...?) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
position of decimal point when entering a number ...
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 ...?) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
position of decimal point when entering a number ...
Try: Tools/Options/Edit and uncheck Fixed decimal HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=499018 |
#4
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 ...?) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
position of decimal point when entering a number ...
Dear HTH,
Thank you. This suggestion, made also by another member of the group, solved all problems. Have a great week-end ! Paul. "pinmaster" wrote: Try: Tools/Options/Edit and uncheck Fixed decimal HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=499018 |
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) |