Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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