The TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This function is useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.

TEXT takes 2 required arguments and no optional arguments:

Syntax: TEXT(value, format_text)

#1)
Using the TEXT function:
#2)
The arguments for the TEXT function are:
Argument Required? Description
value Required A numeric value, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value.
format_text Required A numeric format as a text string enclosed in quotation marks, for example "m/d/yyyy" or "#,##0.00".
#3)
Guidelines for number formats:
#4)
Guidelines for date and time formats:
#5)
Guidelines for currency, percentages, and scientific notation format:
#6)
Guidelines for including text and adding spacing:
#7)
A couple things:
The format_text argument cannot contain an asterisk (*).
Using the TEXT function converts a numeric value to formatted text, and the result can no longer be calculated as a number. To format a cell so that its value remains numeric, see also Cell Formatting.

Summary

The TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This function is useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
comments powered by Disqus