Rational
Formats a value and converts it to text.
Description
The Excel TEXT function allows converting a value to a specific format based on the given format codes. The function is useful to display text after inserting a given number formatting. For example, =TEXT(31-12-2018,”MM/DD/YYYY”) return ” 12/31/2018″. All value modify to Text format.
Syntax
=TEXT (value, format_text)
Parameters
value – The value to format
format_text – Number formatting to apply
Return Value
Formatted value.
Key Notes
- The TEXT function formats a number and converts it to ‘text’ in the desired format. Use VALUE function to text value to its number code (without any attached format).
- The argument of format_text entered manually must appear in double quotation marks.
- The user can apply Custom option formatting by bringing up the Format Cells dialog Ctrl+1 (⌘ +1 on the Mac).
Keep Reading Similar Functions:
VALUE
The VALUE function converts valid numbers with various number formatting (number, date, $ etc.) into a code number. E.g. “=VALUE(“31-12-2017”)” returns “43100”.
TEXT
The TEXT function allows converting a value to a specific format based on the given format codes. E.g. =TEXT(31-12-2018,”MM/DD/YYYY”) return ” 12/31/2018″.
DOLLAR
The DOLLAR function display a number with a dollar currency. I.e. =DOLLAR(500) returns $500 as a currency but in a text format.
BAHTTEXT
The Excel BAHTTEXT function converts a number to Thai currency with a suffix of “Baht”. I.e., to translate $5.50 in cell B7 =BAHTTEXT(B7) returns “ห้าบาทห้าสิบสตางค์”.
FIXED
The FIXED function displays a number in a text format after rounding the specified number of decimal places with or without commas.