Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to clear decimal point?
I'm a Windows 98 user. When I key in 12345, it will automatically display as
123.45. I have check the cell format, is set to normal. I suspect is due to the regional settings that cause this happen. Please advice. |
#2
|
|||
|
|||
Michael
ToolsOptionsEditUncheck Fixed Decimals -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Michael" wrote in message ... I'm a Windows 98 user. When I key in 12345, it will automatically display as 123.45. I have check the cell format, is set to normal. I suspect is due to the regional settings that cause this happen. Please advice. |
#3
|
|||
|
|||
Try: Format: Cells: number: Decimals Clear the number of decimals to zero that should work -----Original Message----- I'm a Windows 98 user. When I key in 12345, it will automatically display as 123.45. I have check the cell format, is set to normal. I suspect is due to the regional settings that cause this happen. Please advice. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
How do I enter a decimal automatically without typing it every ti. | New Users to Excel | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) |