TEXT Function

---

In Microsoft Excel, the TEXT function is used to convert a value to text in a specific number format. The syntax for the TEXT function is as follows:

Syntax

• value: This is the numeric value that you want to convert to text.
• format_text: This is the format you want to apply to the value. It could be a predefined number format or a custom format.

Example

In this example, if the date in cell A1 is, for instance, 2023-08-06, the formula would convert it to text in the format "08/06/2023".

Formula

Output

Here are a few more examples of how you can use the TEXT function:

Number formatting:

This would format the number in A1 with commas as thousand separators and two decimal places.

Formula

Output

Date formatting:

Formula

This would display the date in the format "Sunday, August 6, 2023".

Output

Custom text formatting:

If A1 contains the number 0.25, this formula would display "25%".

Formula

Output

Remember to adjust the format_text argument based on the formatting you want to apply to your specific data. Excel provides a variety of built-in date and number formats, and you can also create custom formats using a combination of characters.

• Previous
• Next

Advance Excel 365

---

Introduction to Microsoft Excel

---

• What is Excel 365
• Microsoft Excel
• Microsoft Excel Formulas and Functions

Mathematical Functions

---

• SUM Function
• AVERAGE Function
• MAX Function
• MIN Function
• ROUND Function
• SUMIF Function
• COUNT Function
• COUNTA Function
• COUNTIF Function

Date And Time Functions

---

• NOW Function
• TODAY Function
• YEAR Function
• MONTH Function
• DAY Function
• HOUR Function
• MINUTE Function
• SECOND Function
• TIME Function

Text Functions

---

• CONCATENATE Functions
• LEN and MID Function
• TRIM Function
• TEXT Function
• LEFT Function
• RIGHT Function
• UPPER Function
• LOWER Function
• PROPER Function
• REPT Function
• EXACT Function

Logical Functions

---

• IF Function
• VLOOKUP Function