Excel TEXT() Function

The TEXT () function in excel converts a supplied numerical value into the text of a specific format.

Syntax

TEXT(Value, Format_text)

Parameter

Value (required)- This parameter represents the value for which we need to change the format.

Format_Text (required)- This parameter represents the old text which you want to replace.

Category

Text

Return

This function returns a text based on the format given by the user.

Example 1

Objective: Get the values in Col A in text format by using the TEXT function

Col A Result Formula
3/27/2017 27/03/2017  =TEXT(A18, "dd/mm/yyyy")
42821 27/3/2017  =TEXT(A19, "dd/m/yyyy")
42821 Mar 27 2017  =TEXT(A20, "mmm dd yyyy")
3/27/2017 Mar-17  =TEXT(A21,"mmm-yy")

Example 2

Objective: Get the values in Col A in text format by using the TEXT function

Col A Result Formula
14.141414 14.14  =TEXT(A22, "0.00")
14598.12 $14,598.12  =TEXT(A23, "$#,##0.00")
14598.12 £14,598.12  =TEXT(A24, "£#,##0.00")
14:00 14:00  =TEXT(A25, "hh:mm")

Example 3

Objective: Get current date with a text message

Result Formula
Today's date is 17-Nov-19 =CONCATENATE("Today's date is ",TEXT(TODAY(),"dd-mmm-yy"))



ADVERTISEMENT
ADVERTISEMENT