How to Use TEXT Function in Excel

The TEXT function converts a value into formatted text. Use it when a formula needs to produce a readable label, sentence, report title, invoice note, or status message without changing the original number or date.

TEXT is especially useful in reports built from budget, invoice, CRM, and operating data where the output needs to be readable by someone who will not inspect the formula.

The syntax

• value — the number, date, or cell reference you want to format
• format_text — the Excel number format wrapped in double quotes

The result is text, not a number. That matters if you want to use the output in later calculations.

Step 1. Format a date inside a sentence

If A2 contains an invoice date, this formula creates a readable label:

If A2 is 5/1/2026, the result is Invoice date: May 1, 2026.

This is cleaner than manually typing month names or building separate helper columns for day, month, and year.

Step 2. Format currency

If B2 contains a total amount:

That turns 1250 into Total due: $1,250.00.

This pattern is useful in an invoice template or a monthly budget summary where the label needs to include the formatted amount.

Step 3. Format percentages

If C2 contains margin as a decimal, format it as a percentage:

If C2 is 0.342, the result is 34.2%.

That can make summary notes easier to read in a small business budget where margin is part of the management review.

Step 4. Build dynamic report labels

TEXT is often used with concatenation:

This creates a label like Budget review for May 2026: $42,000.

Common format codes

The Griddy way

TEXT formulas are useful, but format codes are easy to forget and hard to audit when they get buried in report labels.

"Create a monthly budget summary label that shows the month, total revenue as currency, and gross margin as a percentage"

Griddy writes the formula, keeps the source values intact, and places the formatted output where the report needs it.

Formatting versus changing a value

TEXT returns text. That is useful for labels such as "Due "&TEXT(A2,"mmm d"), but the result should not be used as the numeric input for later arithmetic. Keep dates and amounts as real values in the source columns, then use TEXT only in a presentation or label column. If you need a date to sort or filter chronologically, retain the original date and format the cell instead.

The format code must match the value’s meaning. For example, "0.0%" displays a decimal as a percentage, while "$#,##0.00" displays currency. Locale settings can affect separators and currency symbols, so check the workbook’s audience before hard-coding a client-facing label. A custom cell number format is often better when the value must remain numeric.

Sources

• Microsoft Support: TEXT function
• Microsoft Support: Text functions reference