TEXT Function: 7 Major Uses

It may seem inconspicuous, but the TEXT function can play a significant role. This time we specifically point out seven major uses of the TEXT function.
The unassuming TEXT function can be powerful — study it carefully. This time we highlight 7 key uses of the TEXT function.

The basic syntax is:
Basic syntax is:

=TEXT(value to be processed, “format code to be used”)
=TEXT(value, "format_text")

1. Add a dollar sign to amounts
   Add a $ sign to amounts: =TEXT(D2, "$0元")
   

   ---

2. Convert date formats
   Convert date format: =TEXT(C2, "e年mm月dd日 aaaa")
   

   ---

3. Simple employee evaluation
   Simple employee evaluation: =TEXT(D2-500,”超額0元;還差0元;剛好”)
   

   ---

   ---

4. Convert amounts to uppercase
   Convert amount to Chinese uppercase: =TEXT(D2,”[DBNum2]0元”)
   

   ---

5. Calculate hours
   Calculate hours: =TEXT(D2-C2,”[h]”)
   

   ---

6. Concatenate text and percentages
   Concatenate text and percentage: =”已完成”&TEXT(A2,”0%”)
   

   ---

7. Simplify formula judgments
   Simplify formula logic: =TEXT(C2-B2,”比上年多0元;比上年少0元;與上年相同”)