Menu
EXCEL TEXT FUNCTION
Excel TEXT Function Introduction
This method converts a number to text and allows you to customise the display formatting with format strings. Assume that cell A1 has the integer 43.8. To format the number as a dollar amount, use the expression TEXT(A1,”$0.00″), which yields the result $43.8.
You may also add a text to the above formula, such as =TEXT(A1,”$0.00″) & “per Miles,” to get the result $43.8 per Miles.
Description of Excel TEXT Function
Syntax:
=TEXT (value, format_text)
Parameter list:
- value – The value to be converted.
- format text – The integer format to be used, which must be enclosed in double quotation marks.
Step By Step Guide of TEXT Function
Example :
- Currency with a numbers separator and two decimal places, such as $1,234.57. Excel rounds the number to two decimal places.
- Today’s date in MM/DD/YY format, for example, 03/14/12
- Today, like Monday, is a weekday.
- 1:29 PM is the current time.
- Fraction, such as 4/3 Fraction, such as 1/3 It’s worth noting that this use the TRIM function to eliminate the leading space with a decimal value.
Key Points
The TEXT function allows you to modify the appearance of a number by formatting it using format codes. It comes in handy when you wish to present numbers in a more legible style or combine numbers with text or symbols.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
