How to Use the TEXT Function in Excel (Custom Number & Date Formatting)

How to Use the TEXT Function in Excel (Custom Number & Date Formatting)

The TEXT function in Excel is a powerful way to apply specific formatting to numbers and dates, especially useful when combining data inside strings.

📘 Syntax:

=TEXT(value, format_text)

✅ Parameters:

• value – The number or date you want to format
• format_text – A string that defines the formatting

📌 Example:

=TEXT(TODAY(), "dd-mm-yyyy")

Returns today’s date in dd-mm-yyyy format.

🎯 Use Cases:

• Format currency: =TEXT(1234.5, "$#,##0.00")
• Format date: =TEXT(A1, "mmmm yyyy")
• Combine text and numbers: =TEXT(A1,"0.00") & " kg"

💡 Pro Tip:

Use TEXT in dashboards to keep formatting consistent without changing raw data.

For more Excel tips like this, follow ScriptDataInsights.