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.
Returns text. The value rendered in the given format. The live engine supports a subset of Excel's format codes.
TEXT converts a value to text in the exact format you specify. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =TEXT(A2,"0.00") | 1234.50 | Two decimal places |
| =TEXT(A2,"$0.00") | $1234.50 | Literal currency symbol |
| =TEXT(A2,"0") | 1235 | Rounds to a whole number |
| =TEXT(A5,"000") | 003 | Zero-pads to three digits |
| =TEXT(C2,"yyyy-mm-dd") | 2026-11-16 | ISO date from a serial |
| =TEXT(C2,"mm/dd/yyyy") | 11/16/2026 | US date format |
| =TEXT(C2,"yyyy") | 2026 | Year only |
| =TEXT(A7,"hh:mm") | 12:00 | Time from a fractional day |
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 code | Live engine (HF) | Real Excel | Status |
|---|---|---|---|
| #,##0.00 | 1235,##0.00 | 1,234.50 | diverges |
| #,##0 | 1235,##0 | 1,235 | diverges |
| 0% (on 0.075) | 0% | 8% | diverges |
| mmm (on 2026-11-16) | 110 | Nov | diverges |
| dddd (on 2026-11-16) | 1616 | Monday | diverges |
| 0.00 | 1234.50 | 1234.50 | supported |
| yyyy-mm-dd | 2026-11-16 | 2026-11-16 | supported |
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.
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.
TEXT is a core text function present in every Excel version; format-code coverage varies by engine (see the measured matrix).
| Platform | Support | Notes | Gotcha |
|---|
TEXT is one piece. The full course walks the toolkit end to end with live, measured examples.