Fix Excel 365 Removing Decimal Points from Entered Numbers
Question details
The user needs Excel 365 to retain decimal points when entering numbers.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Entering values such as 0.125654 into a worksheet.
- Observed behavior
- Excel changes some entries to numbers such as 125654, and the changed value may also appear in the formula bar.
Check whether the changed value appears only in the cell or also in the formula bar. Have a sample decimal value ready to test in a new workbook.
Check the cell number format
Use this check when the decimal point appears to be missing from the worksheet display.
Formatting changes how a number is displayed, not its stored value. If the formula bar also shows 125654 instead of 0.125654, changing the format alone will not restore the original value.
Select the cells that display numbers without the expected decimal point.
On Windows, press Ctrl+1, or right-click the selection and choose Format Cells.
On the Number tab, select General and choose OK. Check the cell and formula bar again.

Check Excel's decimal separator settings
Use this check if Excel interprets a typed decimal point as a thousands separator.
Test whether the issue is specific to one workbook
Isolate the problem and gather information if the formatting and separator checks do not resolve it.
Work with decimal values in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. Open compatible Excel files to continue working with numbers and move between office suites more easily.

Frequently Asked Questions
Why does the formula bar also show the wrong number?
If the formula bar shows 125654 instead of 0.125654, the issue is not just the cell's display format. Check the decimal separator settings, then re-enter the original value from a reliable source.
Where can I change the decimal separator in Excel?
In Excel for Windows, go to File > Options > Advanced. Under Use system separators, you can review the decimal and thousands separators or use the system settings.
Will changing the cell to General restore a missing decimal point?
General can reveal a decimal value that was hidden by formatting, but it cannot restore a decimal point if Excel stored a different number. Check the formula bar to distinguish the two cases.
How can I tell if the problem affects every workbook?
Choose File > New > Blank workbook, enter the same decimal value, and compare the cell and formula bar with the original workbook.




