Excel-text function Detailed function

1. Convert the value to text:

“@”

2. Convert to a specific time format:

"YYYY year MM DD Day"

"Yyyy/mm/dd" "yyyy/m/d"

"Yyyy-mm-dd" "yyyy-m-d"

"MMMM"--full spelling of the month in English

Expand: "August&1" can convert month English to month number.

Expand: Returns the date of the last day of last month:=today ()-day (today ())

Expand: Return to the beginning of this month date:=today ()-day (today ()) +1

"MMM"--English shorthand for the month

"Hh:mm:ss" "H mm min"

"dddd"--return "Day of the Week"

"DDD"--abbreviated form

"AAAA" for the Chinese week a few AAA abbreviated, such as "three"

"H-hour mm"

3. Convert to a numeric-specific format:

"0%"

"￥00.00"

“##.##”

"Positive number; negative number; 0"

"[Dbnum1]"--Chinese lowercase numbers

"[Dbnum2]"--Chinese capital number

Expand: Show Uppercase Dates

"[DBNUM3]"--lowercase digit uppercase sub-position

4. Special Judgment Method:

[ >=90] excellent; [>=60] pass; fail "-- [] Set the conditions, followed by the results, you can have different results have different display, to achieve similar if function effect.

Appendix: Common Format_text

Excel-text function Detailed function