Calculation Issues

Why Excel Shows 2.01 Minus 2 as 0.0099999999999998 and How to Fix It

Elise Williams Oct 1, 2026 869 views

Question details

Users notice that subtracting 2 from 2.01 in Excel results in an extended fraction like 0.0099999999999998 instead of the exact expected decimal 0.01.

Why Excel Shows 2.01 Minus 2 as 0.0099999999999998

Product: Microsoft Excel
Device & OS: not provided
Scenario: Performing basic decimal subtraction or arithmetic calculations where exact decimal precision is expected for financial or reporting purposes.
Observed behavior: Excel displays a trailing string of nines and an eight (0.0099999999999998) instead of 0.01. This is a known effect of binary floating-point approximation.

Before you start

Understand that this is a standard behavior of 64-bit binary floating-point arithmetic used by most spreadsheet software, not a bug or calculation failure.

Solution 1Recommended

Use the ROUND Function to Fix Precision Errors

Wrap your calculations in the ROUND function to force Excel to evaluate the result to a specific number of decimal places.

Because 0.01 cannot be represented exactly in binary code, Excel stores the closest approximation. Using the ROUND function eliminates the tiny rounding differences caused by this approximation.

Select the target cell

Click on the cell where you want the exact calculation result to appear.

Enter the ROUND formula

Instead of typing the basic subtraction formula =2.01-2, type =ROUND(2.01-2, 2). The '2' tells Excel to round the output to two decimal places.

Apply the calculation

Press Enter. Excel will now accurately display and store the expected decimal result of 0.01.

Use the ROUND Function to Fix Precision Errors

Precision Restored: Using the ROUND function is the most reliable way to prevent floating-point anomalies from affecting downstream calculations and logical comparisons.

Solution 2

Enable 'Set precision as displayed' Option

Change Excel's advanced settings to permanently force calculations to use the visible, rounded numbers instead of the underlying floating-point values.

Advanced Spreadsheet Tool

Fix Floating-Point Errors Instantly in WPS Spreadsheet

WPS Office offers a fully compatible spreadsheet tool that handles complex financial formulas and precision settings with ease. You can fix floating-point precision errors using the exact same ROUND function while enjoying a fast, lightweight, and completely free application.

1. Open your file in WPS Office: Launch WPS Spreadsheet and open the document containing your calculations.
2. Apply the function: Select the target cell and type your formula using the ROUND function, such as =ROUND(2.01-2, 2).
3. Confirm the result: Press Enter to get a clean, precise result without trailing decimals, safely avoiding floating-point limitations.

Fully compatible with Microsoft Excel formulas, functions, and .xlsx files.Comprehensive library of Math and Financial functions, including ROUND, to prevent calculation issues.Free, lightweight, and fast-loading alternative for daily spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Does upgrading to 64-bit Excel fix this rounding issue?

No. Both 32-bit and 64-bit Excel use the exact same 64-bit binary floating-point numbers for calculations. The terms '32-bit' and '64-bit' refer to the application's software architecture and memory limits, not its numeric precision.

Why does Excel use binary floating-point instead of exact decimals?

Excel and most modern applications use the IEEE 754 standard for floating-point arithmetic because it allows the software to process calculations incredibly fast and handle massively large or microscopically small numbers efficiently.

Can I just format the cell to show fewer decimal places instead of using ROUND?

Cell formatting only changes how the number looks on the screen, not the underlying value. If you use that cell in another formula, Excel will still calculate using the unrounded floating-point value (e.g., 0.0099999999999998), which can lead to compounding errors in your data.

Excel & Data Problems