Published on 2025-12-08T00:02:25+08:00
TEXT Function: Format Numbers as Text
TEXT Function: Format Numbers as Text
Syntax
=TEXT(value, format_text)Number Formats
| Formula | Result |
|---|---|
| =TEXT(1234.5, "#,##0.00") | 1,234.50 |
| =TEXT(0.25, "0%") | 25% |
| =TEXT(1234, "$#,##0") | $1,234 |
| =TEXT(5, "000") | 005 |
Date Formats
| Formula | Result |
|---|---|
| =TEXT(TODAY(), "YYYY-MM-DD") | 2024-12-07 |
| =TEXT(A1, "MMMM D, YYYY") | December 7, 2024 |
| =TEXT(A1, "DDD") | Sat |
| =TEXT(A1, "DDDD") | Saturday |
Time Formats
| Formula | Result |
|---|---|
| =TEXT(NOW(), "HH:MM:SS") | 14:30:45 |
| =TEXT(A1, "H:MM AM/PM") | 2:30 PM |
Combining Text and Values
="Total: "&TEXT(SUM(A:A), "$#,##0.00")Common Format Codes
| Code | Meaning |
|---|---|
| 0 | Digit placeholder (shows 0) |
| # | Digit placeholder (no leading 0) |
| , | Thousands separator |
| . | Decimal point |
| % | Percentage |
Conclusion
TEXT is essential for creating dynamic labels and professional reports.
Share this article
Related Posts
Master the TEXT function to format numbers, dates, and times exactly how you want them displayed in Excel.
2025-12-08T00:02:25+08:00
Learn to use Excel IF function for logical tests, create nested IF statements, and use modern alternatives like IFS and SWITCH.
2025-12-08T00:02:25+08:00
Master conditional summing in Excel with SUMIF for single criteria and SUMIFS for multiple criteria calculations.
2025-12-08T00:02:25+08:00