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!
Comments
Post a Comment