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