# Excel Convert numbers to Text

This post will guide you how to convert numbers to text with the Excel TEXT function. Assuming that you want to display leading Zero in numbers in cell, then you need to convert them into Text based on the specified Format_text. So you can use TEXT function to achieve this in Excel.

The Text function will accept a numeric value as the first argument, then based on the format code in the second argument to convert the number to text. You can convert all the standard number formats such as: dates, times, currency to Text string in excel.

## Convert Number to Text with Text Function

If you just want to convert the numbers in the cell to Text without any formatting, then you can use the below generic formula of Text function in excel:

`=Text(B1,"0")`

​In the above formula, it will convert the number to text string with no special formatting, as we just use the most simply format text as “0“.

If you want to display the leading zero in numbers, then you can use the format_text as “0000” in the Excel Text function as follows:

`=Text(B1,"0000")`

If you want to convert the number in cell B1 to text string which keep three decimal digits, the following format text can be used in the Excel Text function:

00.000

we can write down the formula using Text function in excel as follows:

`=Text(B1,"00.000")`

For more format codes in excel formatting, you can refer to the below table:

 Format Code Description Examples 0 only display digits in its place #.00 – Forces the function to display two decimal places =Text(34.234,”\$##.00″) result: \$34.23 # Display the placeholder =Text(4.527,”#.##) result: 4.53 . the position of Decimal Point =Text(342.2,”0.00″) result: 342.20 d Day of the month or day of week d- one or two digit number (1-31) dd- two digit number (01-31) ddd-abbreviated day of week (Mon to Sun) dddd-full name of day of week(Monday to Sunnday) =Text(TODAY(),”DDDD”) result: Monday m The Month of the Year m- one or two digit number mm-two digit number mmm-abbreviated month(Jan to Dec) mmmm-full name of month(January to December)) =Text(TODAY(),”MM/DD/YY”) result:11/06/17 y year yy-two digit representation of year(e.g.01,17) yyyy-four digit representation of year(e.g. 2001,2017) =Text(TODAY(),”MM/DD/YY”) result:11/06/17 h Hour h-one or two digit number (e.g. 1,23) hh-two digit number (e.g. 01,23) =Text(14:16,”hh:mm”) result: 14:16 m Minute m-one or two digit representation (e.g. 1,59) mm-two digit representation (e.g. 01,59) =Text(14:16,”hh:mm”) result: 14:16 s Second s-one or two digit representation (e.g. 1,59) ss=two digit representation (e.g. 01,59)

### Related Functions

• Excel Text function
The Excel TEXT function converts a numeric value into text string with a specified format. The TEXT function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The syntax of the TEXT function is as below: = TEXT (value, Format code)…
Related Posts

How to apply a formula in entire column or row without/with dragging

This post explains that how to apply an excel formula in entire column or row through dragging fill handler in excel. How do I apply formula in entire column or row without dragging fill handler by shortcut or Fill command. ...

Get the Current Workbook Name

This post explains how to get the current workbook name in excel. Get the Current Workbook Name In excel, the CELL function can get the information of the current worksheet, it will return the full file name and its path. ...

Split Text and Numbers in Excel

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can ...

Split Text String by Specified Character in Excel

This post explains how to split text string by a specified character (such as: comma, space, dash, slash, etc.) using FIND function within other functions in excel. And you will learn that how to extract part of characters to the ...

Excel Replace Function Remove Text String

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Sidebar