How to Use the TEXT Function in Excel (Format Numbers and Dates)

How to Use the TEXT Function in Excel (Format Numbers and Dates)

The TEXT() function is used to convert a number or date into a specific format using text formatting codes. It’s especially useful when building reports and dashboards that need clean formatting.

📘 Syntax:

=TEXT(value, format_text)

✅ Example 1 – Format a Date:

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

This will display the date as 24-Jul-2025.

✅ Example 2 – Format a Number:

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

This will display 12345.678 as 12,345.68.

🎯 Common Uses:

• Custom date display for reports
• Showing currency without changing cell type
• Dynamic text in dashboards (e.g., “Sales as of 24-Jul-2025”)

🧠 Pro Tip:

Combine with CONCAT or “&” to make dynamic sentences, like:
"Sales total: " & TEXT(B2,"₹#,##0")

Follow ScriptDataInsights for more Excel power tips!