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.
Returns a number. Parses numeric text, trims spaces and reads percent; non-numeric text returns #VALUE!.
The inverse of TEXT. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =VALUE("1234.5") | 1234.5 | Numeric text to a number |
| =VALUE("0.075") | 0.075 | Decimal text |
| =VALUE(" 42 ") | 42 | Surrounding spaces trimmed |
| =VALUE("50%") | 0.5 | Percent text scales to a fraction |
| =VALUE(A2) | 1234.5 | A number passes through |
| =VALUE(TEXT(A2,"0.00")) | 1234.5 | Round-trip through TEXT |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to coerce text into a number.
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.
VALUE is a core text function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
VALUE is one piece. The full course walks the toolkit end to end with live, measured examples.