Formatting Numbers as Text With TEXT
Display numbers with currency, percentage, and date patterns.
Why Format as Text
Cell formatting changes how a number looks in its own cell. But what if you want to drop a formatted number inside a sentence, like "Your total is $1,250.00"? For that you need the value turned into formatted text.
The TEXT function converts a number into a text string using a format pattern you choose. The result is text, ready to be combined with words.
The TEXT Syntax
TEXT takes two arguments:
- value the number to format
- format_text a format code in quotes
The format code uses the same symbols as custom cell formats. For example =TEXT(0.25, "0%") returns the text 25%. The output is a string, not a number.
=TEXT(0.25, "0%")All lessons in this course
- Rounding With ROUND, ROUNDUP, ROUNDDOWN
- Truncating With INT and TRUNC
- Rounding to Multiples With MROUND
- Formatting Numbers as Text With TEXT