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.

How to Use the TEXT Function in Excel (Format Numbers and Dates Easily) The TEXT function in Excel is used to convert numbers into text while applying custom formatting to them. 🔸 1. Syntax of TEXT Function =TEXT(value, format_text) value: The number or cell reference. format_text: The format code in quotes. 🔸 2. Format Numbers Example: Format 1234.56 as currency =TEXT(1234.56, "$#,##0.00") Output: $1,234.56 🔸 3. Format Dates =TEXT(TODAY(), "dd-mmm-yyyy") Output: 11-Jul-2025 🔸 4. Format Time =TEXT(NOW(), "hh:mm AM/PM") 🔸 5. Combine Text and Formatted Values ="Invoice Total: " & TEXT(2500, "$#,##0.00") ✅ Use Cases of TEXT Function Convert date to readable text in reports Create custom invoice numbers Make dashboard labels user-friendly 🎯 Want more Excel formatting tips? Follow ScriptDataInsights for your daily dose of Excel mastery!