How to Use the TEXT Function in Excel (Format Like a Pro)

How to Use the TEXT Function in Excel (Format Like a Pro)

The TEXT function in Excel lets you convert numbers, dates, and values into specific text formats. It’s a formatting powerhouse used for reports, dashboards, and labels.

📘 Syntax:

=TEXT(value, "format_text")

✅ Example 1 – Date Formatting:

=TEXT(A2, "dd-mmm-yyyy")

Converts a raw date into a readable format like 15-Jul-2025

✅ Example 2 – Add Currency Symbol:

=TEXT(B2, "$#,##0.00")

Formats number as currency: $1,250.00

🎯 Common Use Cases:

• Clean formatting in dashboards
• Custom date/time display
• Label creation with combined text + numbers

💡 Bonus Example:

=A2 & " earned " & TEXT(B2, "$#,##0.00")

Shows: John earned $1,500.00

📌 Tip:

Use TEXT inside CONCAT or & operator to build readable sentences with values.

Formatting makes your reports look sharp. Follow ScriptDataInsights to learn more smart Excel moves.