TEXT String Formatting Formula

When creating automated billing summaries or executive report titles, analysts often concatenate customer names with balances and due dates:

="Dear " & A2 & ", your balance of " & B2 & " is due on " & C2

Without formatting, the resulting message looks broken: "Dear Acme Corp, your balance of 12450.5 is due on 46332". The dollar sign disappears, comma separators vanish, and the calendar date reverts to an unreadable raw serial integer like 46332.

Excel provides the TEXT formula to convert numbers and dates into formatted strings with custom number formatting codes.

Syntax and Format String Rules

=TEXT(value, format_text)

The second argument must always be wrapped in double quotes:

• Currency: =TEXT(B2, "$#,##0.00") → "$12,450.50"
• Date: =TEXT(C2, "mmm dd, yyyy") → "Nov 15, 2026"
• Percentage: =TEXT(0.125, "0.0%") → "12.5%"

The Text Data Type Reminder

Once converted using TEXT, the resulting value is a text string, not a true number. Do not run SUM on text-formatted cells; use this formula for reporting headers, customer emails, and narrative sentences.

Hands-on Practice Playground

Use the client invoicing schedule below to format currency values, clean date strings, and assemble executive messages. Follow each objective to complete the exercise.

In cell D2, convert balance B2 into currency text with code "$#,##0.00" using TEXT.

In cell E2, convert date C2 into formatted date text using code "mmm dd, yyyy".

In cell F2, build the complete executive message combining client name, formatted balance, and due date.