What is the TEXT Function
The TEXT function converts a number or date into text using a format code you specify. This is useful for combining numbers with text in labels and for showing numbers in custom formats inside a formula.
Formula: =TEXT(value, format_text)
Practical Example 1
A2 contains 45231.5.
Type: =TEXT(A2, dollar hash comma hash hash zero dot zero zero)
Result: $45,231.50
Practical Example 2
Format the current date in a label.
Type: =TEXT(TODAY(), dd-mmm-yyyy)
Result: 17-Oct-2026
Practical Example 3
Combine formatted numbers with text.
Type: =Total: & TEXT(A2, dollar hash comma hash hash zero)
Result: Total: $45,231
Practical Example 4
Format a time.
Type: =TEXT(NOW(), hh:mm AM/PM)
Result: 10:30 AM
When to Use It
TEXT is used for combining formatted numbers with labels, for report titles with dynamic dates, for custom display formats inside formulas, and for any formula where a number or date needs to be shown as formatted text.