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"))