A number stored as text in Excel is a cell whose value is right-aligned, typically flagged with a small green triangle in the top-left corner, and refused by every numeric function in the workbook — SUM treats it as 0, AVERAGE ignores it, and VLOOKUP returns #N/A because the string "123" never equals the number 123. The fix is to coerce the cell back into a real number using one of Excel's built-in commands (the warning menu, Format Cells, or Paste Special), a coercion formula such as =VALUE(A1) or =A1*1, or — when the cell holds an English number phrase like "twenty-five thousand three hundred seventy-six" rather than a string of digits — a local parser that turns the words into a comma-formatted integer you can paste back in. Each method works, but only when the underlying text matches the rule the method expects: digit-only text responds to every approach, mixed text with stray characters needs cleaning first, and English word phrases need a grammar-aware converter before any Excel technique will accept them.
Why Excel Stores Numbers as Text
Three situations account for almost every "stored as text" cell you will see in a workbook. The first is import: when you open a file exported by a different program, the import wizard frequently defaults the column to a Text type to prevent Excel from reinterpreting codes, ZIP prefixes, or scientific notation. The second is the apostrophe trick — typing '00123 in a cell forces Excel to keep the leading zeros and stores the result as a string, which is helpful for product IDs but disastrous when the cell is supposed to hold a quantity. The third is concatenation: any formula that builds a cell with & or TEXT(...) leaves a text type behind regardless of what the input looked like.
Whatever the cause, the symptoms are consistent. The value sits on the left edge of the cell, the status bar shows it as Text instead of Sum or Average, and a small green triangle marks the corner. Functions refuse it: =A1+0 returns a #VALUE! error, =SUM(A1:A10) silently skips the cell, and any chart built on the column refuses to plot the values as numeric markers. Fixing the type is a one-step operation once you pick the right method for the situation.
Built-in Excel Methods to Convert Text to Number
Excel exposes three fast, no-formula routes for converting a range of stored-as-text cells back into real numbers. All three work only on cells whose text is a pure numeric string — anything containing letters, currency symbols, or stray spaces needs cleaning first.
| Method | Best for | How to trigger it |
|---|---|---|
| Error warning → Convert to Number | A small range that already shows the green triangle | Select the range, click the warning icon, choose Convert to Number |
| Format Cells dialog | A range with a known target format | Select the range, press Ctrl+1, set Category to Number, click OK |
| Paste Special → Multiply | A large range where every cell must be coerced at once | Type 1 in a spare cell, copy it, select the target range, Paste Special → Multiply |
The Paste Special trick works because multiplying a text string by 1 forces Excel to coerce the string into a number before the multiplication runs. The cell keeps its visual format (currency, percent, decimal places), but the underlying value is now numeric, so SUM, AVERAGE, and chart axes all see it. The error-warning route is the quickest when Excel has already flagged the cells — it rewrites each value in place without a helper cell or a formula.
Formula Methods: VALUE, NUMBERVALUE, and Arithmetic
When the conversion has to be repeatable, auditable, or live alongside other formulas, use a coercion function in a helper column. Three are worth knowing, and the difference matters when the imported data uses a non-English decimal separator.
- Use =VALUE(A1) for the cleanest, most readable coercion. VALUE accepts any numeric string Excel recognizes and returns a real number, with no locale-specific decimal-separator tricks to worry about.
- Use =NUMBERVALUE(A1, ".", ",") when the text uses a different decimal or thousands separator than your workbook locale. NUMBERVALUE lets you declare both separators explicitly and is the safest choice for imported European or Latin American data.
- Use =A1*1 or =A1+0 when you need a one-off coercion that does not add a visible helper column. The result can be pasted back as values to leave a static numeric cell behind.
Once a column is fixed, copy the new range and Paste Special → Values over the original column so the helper formula is replaced by the converted numeric output and the column is no longer dependent on the formula. This is also the moment to widen the column, apply a thousand-separator style, and lock the format to Number or Accounting — under formatting alone, the cell can revert if a future paste lands as text again.
When the Text Is English Number Words, Not Digits
Every method above assumes the cell holds a numeric string such as "123" or "1,234.50". A different version of the same problem involves prose: a value that arrives as English number words, such as "twenty-five thousand three hundred seventy-six" in a transcript, a contract clause, a form response, or a copied paragraph. Excel has no built-in command for that case — none of VALUE, NUMBERVALUE, or Paste Special will accept letters — so the practical workflow is to convert the words to digits in a separate step, then paste the result into Excel as a number.
The Words to Numbers Converter parses a clear English cardinal integer phrase — from zero through nine hundred ninety-nine billion nine hundred ninety-nine million nine hundred ninety-nine thousand nine hundred ninety-nine — and returns a comma-formatted integer, all inside the current browser tab so the phrase never leaves the machine. The parser is deliberately strict: it recognizes zero through nineteen, the tens from twenty through ninety, plus hundred, thousand, million, and billion; it accepts optional hyphens, the connector "and" in familiar forms like "one hundred and five", and either "minus" or "negative" to introduce a negative value; and it rejects plausible-looking mistakes such as "one million million" or "zero" embedded inside a larger phrase, so the digit you paste into Excel is guaranteed to be the digit the prose meant. The grammar rules follow the Unicode LDML Part 3 rule-based number formatting guidance for English spelling and grouping, with cross-checks against an independent English grammar reference for cardinal forms.
- Copy the English number phrase from the source — for instance, "twenty-five thousand three hundred seventy-six" — and strip any surrounding sentence text, currency labels, units, or punctuation. Reducing the phrase to its bare cardinal form gives the parser a single clean integer to handle.
- Paste the phrase into the converter's input box, choose Convert to digits, and read the comma-formatted integer that appears below. For the example above the result is 25,376, ready to paste.
- If an error appears, correct the highlighted grammar boundary or remove unsupported units, decimals, and surrounding prose. The converter handles integers only, so phrases with "and a half", "point three", or "percent" need their own separate handling.
- Copy the integer result and paste it into the target Excel cell, then format the cell as Number so Excel keeps it as a numeric value. From that point, the standard SUM, AVERAGE, and chart routines will treat the cell as a number rather than as text.
Verifying the Fix and Locking the Number Format
After any conversion, two quick checks confirm the type has actually flipped. First, click the converted cell and read the status bar at the bottom of the Excel window — the indicator should now read Sum (or Count, if the cell is empty) instead of Text. Second, type =ISNUMBER(A1) in an adjacent cell and confirm the result is TRUE. Both checks together catch the cases where a fix only looks successful but the cell is still text under the surface.
Lock the format once the type is correct. Set the cell category to Number or Accounting, set the decimal places and thousand separator you want, and turn off the in-cell warning for "numbers stored as text" if you do not want Excel to keep flagging cells you have intentionally imported. With the format locked, future pastes that match the format will stay numeric, and the small leakage of text values that triggers the green triangle will be limited to new imports rather than spreading through the entire historical dataset.
For important values — financial, legal, or measured — compare the converted cell against the original source before relying on the digits downstream. Import routines can shift decimal places, drop leading zeros on codes you wanted to keep, or interpret a thousand separator as a decimal point, so a five-second visual check is cheaper than rebuilding a formula chain that depended on the wrong value.