TEXT
Formats a number and converts it to text.
TextText CleaningText Processing
What it does
Converts a value to text in a specific number format.
Syntax
TEXT(value, format_text)
Arguments
value(number) — Numeric value to format.format_text(text) — Format string (e.g., "MM/DD/YYYY").
Examples
Format Date
Format today's date.
FORMULA
="Today is " & TEXT(TODAY(), "DDDD")
RESULT
Today is Monday
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | (String) |
Pad with Zeros
Format number as 0000.
FORMULA
=TEXT(123, "0000")
RESULT
0123
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 123 |