TEXT Function in Excel – Convert numeric to text in Excel

TEXT Function in Excel converts numeric value into text, in a user specified format

Syntax of TEXT Function in Excel:

TEXT( value, format_text )

Where,

  • value – A numeric value, that you want to be converted into text.
  • format_text – The format that you want to get the resultant text.

 

Example of TEXT Function in Excel:

Formula

TEXT Function in Excel 1

  • In the above examples text is returned in different date and time formats, with required decimal places, currency formats and also in percentages.

So the result will be

Result

TEXT Function in Excel 2

previous-small TEXT Function in Excel                                                                                                                next_small TEXT Function in Excel