Using the TEXT Function in Excel to Format Numbers and Dates Easily

Using the TEXT Function in Excel to Format Numbers and Dates Easily

The TEXT function in Excel allows you to convert numbers and dates into custom formats. It’s useful for reports, dashboards, and clean presentation.

🔸 Syntax:

=TEXT(value, "format_text")

🔸 Examples:

• =TEXT(45000, "$#,##0") → $45,000
• =TEXT(TODAY(), "dd-mm-yyyy") → 11-07-2025
• =TEXT(0.875, "0.0%") → 87.5%

✅ Why Use TEXT Function?

• Control how dates, numbers, and times appear
• Combine text with values like: "Total: " & TEXT(A1, "$#,##0")
• Works perfectly in dashboards and automated reports

📘 Common Format Patterns:

• "dd-mm-yyyy" – For full dates
• "0.00" – For decimal formatting
• "$#,##0.00" – For currency with commas

📌 Start formatting smarter with TEXT! Follow ScriptDataInsights for more Excel tips every day.