Formatting Issues

How to Fix Unexpected Decimal Digits When Filling an Excel Series

Camila MilosovichCamila Milosovich Nov 10, 2026 873 views

Question details

The user needs to prevent Excel from displaying long strings of extra decimal digits when generating a sequence of decimal numbers.

How to Fix Unexpected Decimal Digits When Filling an Excel Series
Product
Excel
Device & OS
not provided
Scenario
Using the fill handle or formulas to create a continuous series of decimal numbers, such as 2.30, 2.31, and 2.32, down a worksheet column.
Observed behavior
Instead of a clean two-decimal progression, Excel unexpectedly displays values with many extra decimal digits due to binary floating-point precision limits.
Before you start

Before applying these formulas, decide whether you need to fix the actual mathematical value for future calculations or if you simply want to hide the extra decimals using cell formatting.

Solution 1Recommended

Use the ROUND Function to Eliminate Floating-Point Errors

This is the most reliable method for all versions of Excel to ensure each generated number is strictly limited to your desired decimal places.

Excel stores fractional numbers using the IEEE 754 binary floating-point standard. Because some decimals cannot be perfectly represented in binary, tiny precision errors occur. Wrapping your addition in a ROUND function continuously resets the value, preventing these microscopic errors from accumulating into visible extra digits.

1
Enter your starting value

Click on the first cell of your intended series (for example, A1) and type your starting decimal, such as 2.30.

2
Input the ROUND formula

Select the cell immediately below it (A2) and enter the formula: =ROUND(A1+0.01, 2). This adds 0.01 to the previous cell and restricts the result to exactly two decimal places.

3
Fill the formula down the column

Press Enter to apply the formula. Then, select cell A2, click and hold the fill handle in the bottom-right corner, and drag it down to generate the rest of your series.

Use the ROUND Function to Eliminate Floating-Point Errors

Easily Manage Decimal Series with WPS Spreadsheet

WPS Spreadsheet smoothly handles complex formulas, data arrays, and decimal precision. You can use identical mathematical formulas like ROUND and SEQUENCE in WPS Office to cleanly generate your decimal series without dealing with unexpected floating-point digits.

  1. 1. Start your data series: Open a new or existing document in WPS Spreadsheet and type your initial decimal number into the first cell.
  2. 2. Apply the rounding formula: In the cell directly below, type =ROUND([Cell_Reference]+0.01, 2) to dictate exactly two decimal places.
  3. 3. Drag to fill: Press Enter to confirm, then click the small square at the bottom-right of the active cell and drag downward to complete the series.
  4. 4. Adjust display formatting: Highlight your generated column, right-click and choose 'Format Cells', then set the Number category to display exactly 2 decimal places.
100% compatible with Microsoft Excel formulas, including ROUND and dynamic arrays like SEQUENCE.Intuitive cell formatting options to easily control decimal precision and display.Lightweight architecture ensures smooth scrolling and calculation even with massive data series.Free to use with a familiar, tabbed interface that requires no learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel add unexpected decimal digits when I drag to fill numbers?

Excel calculates fractional numbers using binary floating-point precision. Because certain decimals cannot be represented exactly in binary code, tiny microscopic errors naturally occur. When you repeatedly add a decimal (like 0.01) down a column, these tiny errors compound until they become visible as a long string of extra digits.

Will changing the cell format to two decimal places fix the calculation error?

Changing the cell format only alters how the number visually appears on your screen; it does not change the underlying raw value stored in the cell's memory. If you use those cells in other highly precise calculations, the hidden floating-point error will persist. Using the ROUND function is necessary to actually change the stored mathematical value.

Can I use the 'Precision as displayed' setting to fix floating-point issues?

Yes, you can navigate to File > Options > Advanced and check 'Set precision as displayed'. However, you should use this with extreme caution. This setting permanently alters all numerical data in the entire workbook to match its displayed decimal places, which might cause permanent unintended data loss in other sheets that rely on high precision.