TEXT

Change the format of a number and converts it to text in Excel
Formats a data type and converts it to text

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:

Change the format of a number and converts it to text in Excel

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

Read More »
Convert number to currency (Dollar) in Excel

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.

Read More »
Round a number to decimal places with or without commas in Excel

FIXED

The FIXED function displays a number in a text format after rounding the specified number of decimal places with or without commas.

Read More »
Convert a text string without number format in Excel

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

Read More »
Converts number Thai currency Excel

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 “ห้าบาทห้าสิบสตางค์”.

Read More »