Data layout · Short guide

Why doesn't Excel add numbers? Numbers stored as text

Braxorn · Last updated 2026-11-22 · English

A cell that looks like a number may actually be text. Especially with externally received data, this affects the collection, sorting and matching results. Simply giving a number format to a cell does not always convert existing text to a number.

What can you do?

  1. Examine the error indicator of the problem cell and its contents in the formula bar.
  2. Select the cells that are actually quantities; Use the Convert to Number option if available in the error indicator.
  3. In the large table, convert a few cells first; Check that the decimal and thousands separators are interpreted correctly and expand the operation. Let

A small example

A2 be the real number 12, and A3 be the text entered with an apostrophe at the beginning, 18. =SUM(A2:A3) can only return 12. When A3 is converted correctly, the result should be 30.

What to watch for

Product code, telephone, zip code and long ID number are not quantities. Converting them to numbers may lose leading zeros or precision.

Check the result

After conversion, compare both the sum and several unique cells.

Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.

Microsoft source (English)

Microsoft source (English)

Review your own workbook

You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.

Review your file