How to clear decimal point?

M

Michael

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.
 
N

Nick Hodge

Michael

Tools>Options>Edit>Uncheck Fixed Decimals

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
G

Guest

Try:
Format:
Cells:
number:
Decimals
Clear the number of decimals to zero
that should work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How to format without decimal point unless significant digits? 3
Formatting Decimal points 2
A couple questions BEFORE using Office 365 0
How to retrieve number of visible digits after decimal point in VBA 8
text box in userforms and international number format 0
Decimal point vs comma 1
Force zeros in Excel 2007 when cells blank and keep commas for thousands 0

Top