The TEXT function in Excel is used to convert a numeric value into text and format it in a specified way. This is particularly useful when you need to display numbers in a specific format, such as dates, times, or currency.

Syntax:

TEXT(value, format_text)

• value: The numeric value you want to convert to text.
• format_text: The format you want to apply to the value, enclosed in double quotes.

Examples:

1. Formatting Dates:

   =TEXT("2023-10-05", "yyyy年mm月dd日")
   

   Result: “2023年10月05日”

2. Formatting Currency:

   =TEXT(1234.56, "$#,##0.00")
   

   Result: “$1,234.56”

3. Formatting Time:

   =TEXT("14:30", "hh:mm AM/PM")
   

   Result: “02:30 PM”

Tips:

• The TEXT function does not change the actual value of the cell; it only changes how the value is displayed.
• You can use custom formats to display numbers in various ways, such as adding leading zeros, displaying percentages, or using scientific notation.