TEXT
TextintermediateTEXT converts a number or date into a formatted text string. It's essential when you need to display dates in a specific format, add number formatting inside CONCATENATE, or build text that includes formatted values. The result is always text (not a number), so don't use it in calculations.
Syntax
=TEXT(value, format_text)Parameters
valueThe number or date to format.format_textThe format code (e.g., "MM/DD/YYYY", "$#,##0.00", "0%").? = optional parameter
Worked Example
Display an invoice date as 'January 2025' instead of '2025-01-15'.
| Row numbers | A | D | |
|---|---|---|---|
| Header row | invoice_id | invoice_date | formatted |
| 2 | INV-1001 | 2025-01-15 | January 2025 |
| 3 | INV-1004 | 2025-02-03 | February 2025 |
| 4 | INV-1008 | 2025-03-05 | March 2025 |
Formula
=TEXT(B2, "MMMM YYYY")Result
January 2025TEXT takes the date in B2 and formats it as the full month name followed by the four-digit year. In this sample, B2 contains 2025-01-15, so the formatted result is 'January 2025'.
Practice Exercises
2 exercises - work through each one using the data table below
Question
Format the amount of the first invoice (INV-1001) as a dollar string with commas and two decimal places, like '$12,500.00'. What format code would you use in the TEXT formula?
Dataset
Showing rows 1-5
Download CSV| Row numbers | A | B | C |
|---|---|---|---|
| Header row | |||
| 2 | INV-1001 | Cloudline Software | $12,500.00 |
| 3 | INV-1002 | Apex Office Supply | $487.50 |
| 4 | INV-1003 | Summit Consulting Group | $18,750.00 |
| 5 | INV-1004 | Meridian Travel Co. | $3,200.00 |
| 6 | INV-1005 | Forge & Frame Creative | $7,600.00 |
| 7 |
Scroll to explore the table, then sort or filter by column as needed.
Hints
Your Answer
Question
Create a sentence for the first invoice that reads: 'Invoice INV-1001 dated Jan 15, 2025 for $12,500.00'. Use CONCATENATE or & with TEXT to format the date and amount.
Dataset
Showing rows 1-5
Download CSV| Row numbers | A | B | C | D |
|---|---|---|---|---|
| Header row | ||||
| 2 | INV-1001 | Cloudline Software | 2025-01-15 | $12,500.00 |
| 3 | INV-1002 | Apex Office Supply | 2025-01-18 | $487.50 |
| 4 | INV-1003 | Summit Consulting Group | 2025-01-22 | $18,750.00 |
| 5 | INV-1004 | Meridian Travel Co. | 2025-02-03 | $3,200.00 |
| 6 | INV-1005 | Forge & Frame Creative | 2025-02-08 | $7,600.00 |
| 7 |
Scroll to explore the table, then sort or filter by column as needed.
Hints
Your Answer
Want more practice?
Test Me mode randomizes exercises across all formulas without telling you which formula to use.