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