Format numbers, dates, and times as text in a specific format.
Description: The numeric value to be converted into text. This can be a number, a cell reference, or a formula.
Example: 1500.35, A1, or =SUM(B1:B5)
Description: A text string that defines the formatting to be applied to the value. Must be enclosed in double quotes.
Example: "$#,##0.00", "MM/DD/YY", "0.0%"
| Scenario | Formula | Result |
|---|---|---|
| Format a number as currency | =TEXT(1234.5, "$#,##0.00") | $1,234.50 |
| Format a date as "DD/MM/YYYY" | =TEXT(TODAY(), "DD/MM/YYYY") | "15/02/2025" (if today is Feb 15, 2025) |
| Format a date as "Month Day, Year" | =TEXT(TODAY(), "MMMM DD, YYYY") | February 15, 2025 |
| Format a time as "HH:MM AM/PM" | =TEXT(NOW(), "hh:mm AM/PM") | 10:30 AM |
| Format a percentage with 2 decimal places | =TEXT(0.854, "0.00%") | 85.40% |
| Format a phone number | =TEXT(0013001234567, "+## (###) ###-####") | +001 (300) 123-4567 |