The Text function converts a numeric value into text in Excel

In the process of working with Excel, when the requirements of the job you need to convert from the number format to text format with the specified format suitable for the purpose of use. The Text function will help you do that.

The Text function converts a numeric value into text in Excel Picture 1

The following article describes the syntax and usage of the Text function in Excel.

Description

The Text function converts a numeric value into text according to the display format you specify.

Syntax

TEXT (value, format_text)

Inside:

- value: is the numerical value to convert to text can also be a formula that returns a numeric value or a parameter to a cell containing a required, numeric value.

- format_text: is the type of display format enclosed in quotation marks, required.

Some number format like: ###, 000, #, ## 0.00 .

Some types of date format such as: dd / MM / yyy, d / MMM / yyyy .

Also you can learn more about other specific formats.

Note

- The format_text argument does not contain an asterisk.

- When using the Text function to convert numerical values into text with the specified format, that result will not be calculated as a number. Want to calculate as a number you need to reformat the Format Cells section .

For example

1. Convert from value to currency format with thousands separator.

The Text function converts a numeric value into text in Excel Picture 2

2. Returns the current date and time in the format dd / MM / yyyy.

The Text function converts a numeric value into text in Excel Picture 3

3. Convert data in incomplete date format to full format dd / MM / yyyy.

The Text function converts a numeric value into text in Excel Picture 4

The use of the Text function is very simple but the efficiency of the function is quite high, the Text function helps you perform data processing better. Good luck!

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

ISNUMBER function - The function returns True if the value is numeric in Excel
isnumber function: the function returns true if the value is numeric. use the function to check if the value is numeric or not. syntax: isnumber (value)
Count function in excel, formula, how to use count function in most detail
in excel, the count function is a powerful tool that helps you quickly count numeric values in a spreadsheet. whether you are new or familiar with excel, mastering the syntax and usage will make calculations easier. let's explore the details in the article below.
Match function in Excel - Usage and illustrative examples
the match function in excel finds a specified item in a specified range and, returns the relative position of that value in this range. function syntax and usage syntax: = match (lookup_value, lookup_array, [match_type]). in which: - match: is the function name. - lookup_value: is the value to search, be it text or numeric.
How to use the TRUNC function in Excel?
there are various ways in excel to remove decimal and shorten numeric values. in this article, tipsmake.com will explain how to use the trunc function and show what makes it different from other techniques.
YEAR - The function for the value is the year of a numeric expression in Excel
year: the function returns the year of any date value, the year value is an integer between 1900 and 9999.
HOUR function - The function converts a serial number into an hour in Excel
hour function: the function returns the hour value in the time value hour minute second or the date value containing the hour.
How to use the SUMIF function in Excel
the sumif function in excel is a function used to compute values in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.
N function - The function returns the numeric value converted from any value other than the error value in Excel
n function: the function returns the numeric value converted from any value. syntax: n (value)
How to delete dots in a series of numbers on Excel
to quickly remove the dot in the numeric sequence in excel, we can use the search or use function in excel.
SUBSTITUTE function - The function replaces text strings in Excel
in the course of working you have excel data file need to change a series of data over the years. with a simple operation, you can change all that data. the following article details the substitute function - the function replaces the text string in excel.