Why Excel Displays Tiny Exponential Values Instead of Zero
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.

- 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.
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.
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.
Click the cell that currently displays the tiny exponential value, or the first total cell in a range.
Type =ROUND(total + temp, 2), replacing total and temp with your actual cell references. For a single sum, use =ROUND(SUM(A1:A10),2).
Press Enter, then drag the fill handle down or across to apply the same rounding to the remaining calculated cells.
Confirm that previously affected cells now show 0.00 or the expected currency value instead of scientific notation.

Use ROUND, ROUNDUP, or ROUNDDOWN for existing formulas
Use this when you prefer to wrap an existing formula inside a rounding function without changing your calculation flow.
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. Open the workbook in WPS Spreadsheets: Launch WPS Office, click Open, and select the Excel .xlsx file that contains the tiny exponential values.
- 2. Select the affected total cells: Click the first cell that shows a value such as -1.70530256582424E-13 instead of zero.
- 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. Save as Excel file: Click Menu > Save or Save As, choose Excel Workbook (*.xlsx), and confirm the corrected results are retained.

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.




