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:

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

• 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