Text · Nov 16, 2026

The TEXT function,
measured & explained.

TEXT turns a value into text in exactly the format you choose — two decimals, a currency symbol, an ISO date, a zero-padded code. It is how you build readable labels, fixed-width IDs and date strings inside formulas. The result is always text, so pair it with VALUE to calculate on it again. This page also measures which format codes the live engine supports versus real Excel.

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

How TEXT works

Returns text. The value rendered in the given format. The live engine supports a subset of Excel's format codes.

=TEXT(value, format_text)
valueThe number or date serial to format.
format_textThe format code, in quotes, e.g. "0.00" or "yyyy-mm-dd".
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Format codes

Number & date format codes

TEXT converts a value to text in the exact format you specify. Click any row to load it.

Codes the live engine supports

ExpressionResultWhy
=TEXT(A2,"0.00")1234.50Two decimal places
=TEXT(A2,"$0.00")$1234.50Literal currency symbol
=TEXT(A2,"0")1235Rounds to a whole number
=TEXT(A5,"000")003Zero-pads to three digits
=TEXT(C2,"yyyy-mm-dd")2026-11-16ISO date from a serial
=TEXT(C2,"mm/dd/yyyy")11/16/2026US date format
=TEXT(C2,"yyyy")2026Year only
=TEXT(A7,"hh:mm")12:00Time from a fractional day
⚠ TEXT always returns TEXT, not a number — you cannot do arithmetic on its result without VALUE. And the live engine (HyperFormula) implements only part of Excel's format-code language; see the coverage table below.
0 = digit, . = decimal point, 000 = zero-pad, yyyy/mm/dd = date parts, hh:mm = time. A literal like $ is kept as-is. Grouping (#,##0), percent scaling (0%) and month/day names (mmm, dddd) are Excel-only.

Format-code coverage: live engine vs Excel

Measured in HyperFormula 3.5. Codes the live engine does not implement are shown with both results — use them in real Excel, not in this playground.

Format codeLive engine (HF)Real ExcelStatus
#,##0.001235,##0.001,234.50diverges
#,##01235,##01,235diverges
0% (on 0.075)0%8%diverges
mmm (on 2026-11-16)110Novdiverges
dddd (on 2026-11-16)1616Mondaydiverges
0.001234.501234.50supported
yyyy-mm-dd2026-11-162026-11-16supported
// 03 — Try it live

Interactive TEXT playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see a supported format code; the coverage table lists Excel-only codes.

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 TEXT works

TEXT is a core text function present in every Excel version; format-code coverage varies by engine (see the measured matrix).

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

Master text

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

  • Always returns text, not a number
  • 0/. /000 for numbers, yyyy/mm/dd for dates
  • Grouping, % scaling and names are Excel-only
  • Pair with VALUE to calculate again
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked