Text · Nov 16, 2026

The VALUE function,
measured & explained.

VALUE is the inverse of TEXT: it takes text that represents a number — "1234.5", "50%", " 42 " — and returns an actual number you can calculate with. It trims surrounding spaces and understands a percent sign, but it does not strip currency symbols or thousands separators in the live engine, which is a divergence worth knowing.

D1
fx
=VALUE(…)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How VALUE works

Returns a number. Parses numeric text, trims spaces and reads percent; non-numeric text returns #VALUE!.

=VALUE(text)
textThe text string that represents a number.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Text to number

What VALUE accepts

The inverse of TEXT. Click any row to load it.

Coercing text into numbers

ExpressionResultWhy
=VALUE("1234.5")1234.5Numeric text to a number
=VALUE("0.075")0.075Decimal text
=VALUE(" 42 ")42Surrounding spaces trimmed
=VALUE("50%")0.5Percent text scales to a fraction
=VALUE(A2)1234.5A number passes through
=VALUE(TEXT(A2,"0.00"))1234.5Round-trip through TEXT
⚠ VALUE("$1,234.50") returns #VALUE! in the live engine because it does not strip the $ or the comma. Real Excel parses it. Clean the string (SUBSTITUTE) first if you need it here.
VALUE trims spaces, reads decimals and percent ("50%"→0.5), and passes numbers through. Non-numeric text returns #VALUE!. Currency/grouping parsing is engine-dependent.
// 03 — Try it live

Interactive VALUE playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to coerce text into a number.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where VALUE works

VALUE is a core text function present in every Excel version and platform.

PlatformSupportNotesGotcha
✓ Supported full VALUE◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master text

VALUE is one piece. The full course walks the toolkit end to end with live, measured examples.

  • Inverse of TEXT
  • Trims spaces, reads percent (50%→0.5)
  • Currency/grouping parsing is engine-dependent
  • Guard non-numeric input with IFERROR
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked