Calculation Issues

How to Stop Excel from Rounding Numbers and Display More Decimals

Nimra Malik Sep 27, 2026 872 views

Question details

Users need to prevent Excel from visually rounding numbers and display the full decimal values instead.

How to Stop Excel from Rounding Numbers and Display More Decimals

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working with precise financial data or scientific measurements where exact decimal representation is required.
Observed behavior: Excel displays fewer decimal places than the underlying value, causing the numbers to appear rounded on the spreadsheet, even though the formula bar shows the true value.

Before you start

Click on one of the rounded cells and look at the formula bar at the top of the screen to verify that the exact unrounded value is still preserved in your worksheet.

Solution 1Recommended

Adjust Number Formatting in Format Cells

This is the most reliable method to specify exactly how many decimal places you want a cell or range of cells to display.

By default, Excel's 'General' number format might truncate decimals if the column isn't wide enough, or apply standard rounding rules visually. Specifying a 'Number' format lets you lock in the exact decimal count.

Select the affected cells

Highlight the specific cell, range, or entire column where your numbers are being rounded.

Open the Format Cells dialog

Right-click the highlighted area and select 'Format Cells' from the context menu, or press Ctrl+1 on your keyboard.

Choose the Number category

In the Format Cells window, go to the 'Number' tab and click on 'Number' in the Category list on the left.

Set decimal places

In the 'Decimal places' box on the right, increase the number to match the level of precision you need, then click 'OK'.

Adjust Number Formatting in Format Cells

Tip: If you just want Excel to display whatever you type exactly as entered, you can also select 'General' from the Category list, provided the column is wide enough.

Solution 2

Use the Increase Decimal Ribbon Button

A quick, single-click solution for adjusting the decimal display of numbers directly from the Excel ribbon.

Solution 3

Disable 'Set Precision as Displayed'

Use this solution if your calculations are actually using the rounded numbers instead of the underlying original values.

Advanced Spreadsheet Formatting

Easily Control Number Precision with WPS Spreadsheet

WPS Spreadsheet offers intuitive formatting tools that give you full control over how your data is displayed. Easily increase decimal places, prevent visual rounding, and maintain high calculation precision for free.

1. Open your file in WPS Office: Launch WPS Spreadsheet and open the document containing the rounded numbers.
2. Select the target cells: Highlight the numbers that need more decimal places displayed.
3. Use the quick action toolbar: Go to the Home tab and simply click the 'Increase Decimal' icon in the Number section.
4. Apply precise formatting: Alternatively, right-click, select 'Format Cells', and define the exact decimal length under the Number category.

Precise control over decimal places and custom number formats100% compatible with Microsoft Excel formats (.xls, .xlsx)Lightweight program with a fast calculation engineFamiliar ribbon interface for seamless transition

microsoft office alternative - wps office

Frequently Asked Questions

Does changing the displayed decimal places alter the actual value used in my formulas?

No. When you increase or decrease decimal places using cell formatting, it only changes how the number looks visually on your screen. Excel continues to use the exact, unrounded underlying value for all mathematical calculations.

Why does Excel change the last digits of my 16-digit numbers (like credit cards) to zeros?

Excel has a maximum calculation precision limit of 15 significant digits. Any numbers entered beyond the 15th digit are automatically converted to zero. To stop this from happening, format the cell as 'Text' before typing the number, or type an apostrophe (') at the beginning of your entry.

Why are my numbers displaying as hash symbols (####)?

When numbers display as ####, it means the column is not wide enough to show the full formatted number, especially after you increase the decimal places. Simply double-click the right boundary of the column header to auto-fit the width, and the numbers will display correctly.

Can I set a default number of decimal places for all new entries?

Yes. You can go to File > Options > Advanced and check 'Automatically insert a decimal point', then specify the number of places. However, be aware this will apply to every number you type, which might not be desirable for standard whole numbers.

Excel & Data Problems