How to Use TEXT Function in Excel + Tips (Video in Khmer)

Hello everyone! Today i will show you how to use TEXT function in Microsoft Excel step by step. Very easy and useful formula for format number, date, and currency!

1. What is TEXT Function in Excel?

The TEXT function in Excel convert a number, date, or time into text format with specific display formatting.

Think of TEXT function like changing clothing style for numbers:

• Change standard number 1250 into currency $1,250.00.
• Change date 2026-09-21 into day name like Monday or short month Sep.
• Combine text and formatted number together, for example: Total revenue is $5,000.00.

2. 🛠️ Formula Syntax & Parameters

The TEXT formula syntax is as follows:

=TEXT(value, format_text)

• value: Required. The number, date, cell reference, or formula result you want to convert to text.
• format_text: Required. The format code enclosed in double quotation marks (e.g., "yyyy-mm-dd", "$#,##0.00", "0000").

3. 📋 Practical Examples

Example 1: Convert Number to Text with Custom Format

You can convert raw numbers to display formatted text like currency or leading zeros.

Example 2: Format Number, Currency, and Accounting Format

Combine static text with formatted numbers seamlessly:

="Total Sales: " & TEXT(B2, "$#,##0.00")

👉 Result: "Total Sales: $12,450.00" (Without TEXT, Excel shows "Total Sales: 12450").

Example 3: Special Format, Date Names & Symbols (រូបមន្ត Text ក្នុង Excel)

Format dates into day of week, month names, or custom symbols:

💡 Quick Tips for Using TEXT Function

1. Output is Always Text: When you use TEXT(), the output is converted into text string! You cannot use standard =SUM() or mathematical formulas directly on this output cell unless you convert it back.
2. Leading Zeros for ID Codes: Use "0000" to make fixed digit numbers (e.g., =TEXT(7, "0000") gives "0007" for employee IDs or product codes).
3. Format Day of Week & Month Name Easily:
   • "ddd" = Mon
   • "dddd" = Monday
   • "mmm" = Sep
   • "mmmm" = September
4. Always Use Double Quotes: The format_text parameter MUST be inside double quotation marks like "#,##0". If you forget quotes, Excel will show error.

📚 Related Resources & Tutorials

• How to Use TAKE Function in Excel
• How to Use CHOOSE Function in Excel
• Top 15 Basic Excel Formulas for Beginners ↗