What TEXT does
TEXT converts a numeric value into a text string using the formatting pattern you choose. It is useful when you need a value to look a certain way inside labels, messages, exports, or concatenated formulas.
Practical examples
Format a date for display
=TEXT(A2,"mmm d, yyyy")
This turns an underlying date serial number into a readable text label such as Mar 14, 2026.
Combine text and numbers
="Revenue: "&TEXT(B2,"$#,##0")
This is a common pattern for dashboard text and summary strings.
Common mistakes and notes
TEXT changes the data type
After TEXT runs, the result is text, not a number. That means later math may fail unless you convert the value back.
Format codes are the whole point
If the output looks wrong, the format code is usually the first thing to review.