Formatting Issues

Fix Excel Status Bar Showing Only One Decimal Place

Rana Garcia Sep 30, 2026 868 views

Question details

The Excel status bar is limiting the display of Sum and Average calculations to only one decimal place, hiding the full precision of the numbers.

How to Fix Excel Status Bar Showing Only One Decimal Place

Product: Microsoft Excel
Device & OS: not provided
Scenario: Selecting a range of cells with multiple decimal places to quickly view their Sum or Average in the bottom status bar.
Observed behavior: The values shown in the status bar are truncated or rounded to a single decimal place, even when the underlying data contains more detailed precision.

Before you start

Verify that the data you are selecting actually contains multiple decimal places and has not been inherently rounded off by existing formulas like the ROUND function.

Solution 1Recommended

Adjust System Display Scaling to 100%

High system display scaling or enlarged font sizes can cause Excel's user interface to truncate decimal places in the status bar.

In many cases, Excel struggles to properly render the full string of numbers in the status bar when the computer's display scaling is set higher than 100%. Reducing the display scaling can restore the missing digits, though it will make text smaller across other applications.

Open Display Settings

Right-click on your desktop background and select 'Display settings' from the context menu.

Change Scaling Value

Scroll down to the 'Scale and layout' section. Click the dropdown menu under 'Scale' and select '100% (Recommended)'.

Restart Excel

Close your Excel workbook completely and reopen it. Select your data range again to verify that the status bar now displays all decimal places.

System-Wide Impact: Changing this setting will affect the size of text, apps, and other items across your entire operating system, which may be inconvenient if you prefer larger text.

Solution 2

Modify the Number Format of the Active Cell

The status bar inherits its number formatting from the active cell within your current selection.

Free Microsoft Office alternative

Try WPS Office for a Bug-Free Spreadsheet Experience

If Excel's display quirks and UI scaling bugs are disrupting your workflow, consider switching to WPS Office. It provides a highly compatible, lightweight, and completely free alternative that handles UI scaling smoothly, ensuring your data is always displayed accurately.

1. Download WPS Office: Visit the official WPS website and download the free installation package.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Excel file.
3. View Accurate Calculations: Select your data range to instantly see fully detailed Sum and Average calculations in the status bar.

Seamless compatibility with Microsoft Excel formats (.xls, .xlsx, .csv).Lightweight architecture that avoids common UI scaling bugs found in heavier software.Free to use with a familiar, easy-to-navigate tabbed interface.Accurate status bar calculations that display full precision without manual tweaking.

Frequently Asked Questions

Why does the Excel status bar round my numbers automatically?

Excel dynamically pulls formatting from the active cell in your selection. If the active cell is formatted to show fewer decimal places, or if your system's display scaling is artificially truncating the UI space, the status bar will appear rounded.

Can I increase the decimal places in the status bar without changing my Windows display scaling?

You can try changing the Number Format of the active cell to display more decimal places via the 'Format Cells' dialog. However, if the issue stems from a Windows update affecting scaling, returning the display scale to 100% might be the only complete workaround.

Which calculations can I see in the status bar?

By right-clicking the status bar, you can toggle several quick calculations for selected cells, including Average, Count, Numerical Count, Minimum, Maximum, and Sum.

Document & File Issues