TEXT Function - Excel
Overview
The TEXT function in Excel is a useful tool for converting a numeric value into text with a specified format. It provides a way to control the display of numeric values by formatting them as text.
Example:
=TEXT(100, "$#,###")
Syntax:
=TEXT(value, format_text)
value: This is the numeric value that you want to convert to text.
format_text: This is the format code that specifies how the value should be formatted as text.
Example
In this example, the TEXT function is used to format the number 10000. The format that we want the number to be displayed in is “$#,###”. This format specifies that we want a “$” symbol at the beginning of the number and that we want a comma after every 3rd number from the right. The final output is “$10,000”.
