![]() |
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. |
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. |
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. . |
All times are GMT +1. The time now is 08:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com