How to Fix Unexpected Decimal Digits When Filling an Excel Series
Question details
The user needs to prevent Excel from displaying long strings of extra decimal digits when generating a sequence of decimal numbers.

- 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 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.
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.
Click on the first cell of your intended series (for example, A1) and type your starting decimal, such as 2.30.
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.
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.

Generate a Clean Decimal Series Using the SEQUENCE Function
For users with Microsoft 365 or newer versions of Excel, generating whole numbers first and then dividing them bypasses floating-point addition errors entirely.
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. Start your data series: Open a new or existing document in WPS Spreadsheet and type your initial decimal number into the first cell.
- 2. Apply the rounding formula: In the cell directly below, type =ROUND([Cell_Reference]+0.01, 2) to dictate exactly two decimal places.
- 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. Adjust display formatting: Highlight your generated column, right-click and choose 'Format Cells', then set the Number category to display exactly 2 decimal places.

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.




