Fix Excel AutoSum Returning Zero for Text Numbers
Question details
The user needs Excel AutoSum to total values that may be stored as text.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Adding a range of values with AutoSum.
- Observed behavior
- AutoSum returns zero instead of the expected total.
Check that the AutoSum formula references the intended cells. Look for a green triangle or warning icon on the source cells, which may indicate that numbers are stored as text.
Convert text numbers using the Excel warning icon
Use this method when Excel identifies the source values as numbers stored as text.
Select the cells included in the AutoSum formula and look for the warning icon beside the selection.
Click the warning icon and choose Convert to Number.
Select the AutoSum cell and verify that its SUM formula includes the converted range. If the result does not update, use Formulas > Calculate Now.

Convert text numbers with the VALUE formula
Use a helper column when the warning icon is unavailable or you want to inspect converted values.
Convert a column with Excel Text to Columns
Use Text to Columns to convert a column of text numbers in place.
Convert text numbers and calculate a total in WPS Spreadsheets
Open the workbook in WPS Spreadsheets, use VALUE to convert text numbers in a helper column, and sum the converted values.
- 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
- 2. Convert the first value: In an empty cell beside the first value, enter =VALUE(A1), replacing A1 with the source cell address.
- 3. Fill the helper column: Drag the formula cell's fill handle down to convert the remaining values.
- 4. Calculate the total: In an empty cell below the converted values, enter a SUM formula such as =SUM(B1:B10), adjusting the range to match the helper column, and press Enter.

Frequently Asked Questions
Why does Excel AutoSum return zero when cells contain numbers?
The values may be stored as text, which SUM ignores when it references a range. Select the source cells and use the warning icon's Convert to Number option if it appears.
How can I tell whether a number is stored as text?
Select the cell and look for a green triangle or a warning icon indicating a number stored as text. These indicators may not appear if error checking is disabled.
Can I convert text numbers without the warning icon?
Yes. Enter =VALUE(A1) in an empty helper cell and fill it down, or select the source cells and use Data > Text to Columns with the General format.
What should I check if the total still does not update?
Select the SUM formula and confirm that it references the converted cells. Then choose Formulas > Calculate Now and check the workbook's calculation settings under Formulas > Calculation Options.




