Formatting Issues

Fix Excel 365 Removing Decimal Points from Entered Numbers

Huda QurayshiHuda Qurayshi Nov 14, 2026 869 views

Question details

The user needs Excel 365 to retain decimal points when entering numbers.

Fix Excel 365 Removing Decimal Points from Entered 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the affected cells

Select the cells that display numbers without the expected decimal point.

2
Open Format Cells

On Windows, press Ctrl+1, or right-click the selection and choose Format Cells.

3
Apply General format

On the Number tab, select General and choose OK. Check the cell and formula bar again.

Check the cell number format
Free Microsoft Office alternative

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.

Enter and format decimal values in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for everyday spreadsheet workWork in a lightweight Office suite
microsoft office alternative - wps office

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.