What is TEXT?
Converts a number to text with a specified format. Essential for displaying numbers, dates, and currencies in custom formats.
Syntax
=TEXT(value, format_text)
Example
Formula: =TEXT(A1, \
Result: $1,234.56
How It Works
Formats the number in A1 as currency with thousand separators and 2 decimal places. TEXT is crucial when concatenating formatted numbers with text strings.