ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to clear decimal point? (https://www.excelbanter.com/new-users-excel/18842-how-clear-decimal-point.html)

Michael

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.

Nick Hodge

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