Calculation Issues

Why Excel Displays Tiny Exponential Values Instead of Zero

Maira MehtabMaira Mehtab Nov 13, 2026 869 views

Question details

The user needs to understand why Excel or WPS Spreadsheets displays very small scientific-notation values instead of zero and how to correct the stored calculation result.

Why Excel Displays Tiny Exponential Values Instead of Zero
Product
WPS Spreadsheets / Microsoft Excel
Device & OS
not provided
Scenario
A spreadsheet calculation that should equal zero or a fixed currency amount is showing a tiny exponential value, such as -1.70530256582424E-13.
Observed behavior
The cell displays a tiny exponential value instead of the expected zero or rounded total.
Before you start

Identify the formulas that produce the tiny exponential values and decide the number of decimal places the result should keep, such as 2 for currency. Check whether the affected cells feed other calculations so the rounding change is applied consistently.

Solution 1Recommended

Round calculated values to the required precision

Use this when totals or sums show tiny exponential residue but should be exactly zero or a fixed decimal such as currency.

Excel and WPS Spreadsheets use IEEE 754 floating-point arithmetic, so some decimal fractions cannot be represented exactly. Formatting only changes the display; rounding changes the stored result.

1
Select the result cell

Click the cell that currently displays the tiny exponential value, or the first total cell in a range.

2
Enter a ROUND formula

Type =ROUND(total + temp, 2), replacing total and temp with your actual cell references. For a single sum, use =ROUND(SUM(A1:A10),2).

3
Press Enter and fill the formula

Press Enter, then drag the fill handle down or across to apply the same rounding to the remaining calculated cells.

4
Verify zero displays correctly

Confirm that previously affected cells now show 0.00 or the expected currency value instead of scientific notation.

Round calculated values to the required precision
Recommended for currency and totals: Rounding changes the stored result, so subsequent calculations use the rounded value rather than the hidden floating-point remainder.
WPS Spreadsheets calculation fix

Fix Tiny Exponential Values in WPS Spreadsheets

Open the same Excel workbook in WPS Spreadsheets, apply rounding functions or adjust the calculation, and save it back as .xlsx. WPS Spreadsheets gives you the same precision controls with a familiar ribbon interface.

  1. 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, click Open, and select the Excel .xlsx file that contains the tiny exponential values.
  2. 2. Select the affected total cells: Click the first cell that shows a value such as -1.70530256582424E-13 instead of zero.
  3. 3. Apply the ROUND function: Replace the formula with =ROUND(existing_formula,2) or type =ROUND(total + temp,2) using your actual cell references.
  4. 4. Save as Excel file: Click Menu > Save or Save As, choose Excel Workbook (*.xlsx), and confirm the corrected results are retained.
Eliminate floating-point artifacts by applying ROUND formulas directly in WPS SpreadsheetsOpens, edits, and saves .xlsx files with full Microsoft Excel format compatibilityFree and lightweight Office suite with a familiar interfaceNo need to re-create formulas or reformat your workbook after migrating
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show -1.70530256582424E-13 instead of 0?

Excel and WPS Spreadsheets use IEEE 754 floating-point arithmetic. Decimal fractions are converted to binary, and some values cannot be represented exactly, leaving a very small remainder after calculations.

Will changing the number format to two decimals fix the problem?

No. Number formatting only hides the extra decimals on screen. The stored value still contains the floating-point remainder, so future calculations can be affected. Use ROUND or a similar function to change the stored result.

How do I round a currency total in WPS Spreadsheets?

Select the result cell and enter =ROUND(total + temp, 2) or wrap the existing formula, for example =ROUND(SUM(A1:A10),2). Press Enter and fill the formula to other cells.

Can I use the same Excel formulas in WPS Spreadsheets?

Yes. WPS Spreadsheets supports Excel .xlsx workbooks and common functions such as ROUND, SUM, ROUNDUP, and ROUNDDOWN, so you can open and correct the workbook without recreating it.

What does Precision as displayed do?

In Excel and WPS Spreadsheets, the Precision as displayed option can round stored values to the displayed format, but it permanently changes workbook data. For targeted currency rounding, use ROUND functions instead.