Assuming that you want to display leading zero in numbers in the cell, then you need to convert them into Text based on the specified Format text. This post will guide you on how to convert numbers to text with the Excel TEXT function. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
- The TEXT Function will accept a numeric value as the first argument, then convert it into the text based on the format code in the second argument.
- In Simple words, the text function converts a number to text in the given format.
- Using this function you can convert all the standard number formats such as date, times, currency to a text string in Excel.
The Syntax of the TEXT function is,
- If you want to convert the numbers in the cell to Text without any formatting, then you can use the below formula.
- First you need to give the input number and apply the given formula.
- It will convert the number to text with no special formatting. Refer to the below image.
- When you need to display the leading zero in numbers means, you can use the below formula.
- The formatted text “0000” will display the text string as follows:
- In case you want to convert the number into a text string that keeps two decimal digits, just use the below formula.
- This formatted text will display the number as a decimal digit values as per the below example image.
The below-given table will help to know more format codes in Excel formatting. Make use of it.
|0||It will display the digits in their place. It can force the function to display at least two decimal places.||=TEXT(18.3012, “$##.00”)|
Output = $18.30
| # | This will display the placeholder. |
Output = 5.66
| . | It shows the position of the decimal point. | =TEXT(45.4, “0.00”)
Output = 45.40
| d | Represents the day of the month or day of the week. | =TEXT(TODAY(), “dddd”)
Output = Monday
Output = 01/04/21
| y | Year | =TEXT(TODAY(), “MM/DD/YY”)
Output = 01/04/21
| h | Hour is represented by one or two-digit number. | =TEXT(15:20, “hh:mm”)
Output = 15:20
| m | Minute | =TEXT(14:15, “hh:mm”)
Output = 14:15
| s | Second | Nil |
In this short article, you can easily learn the instructions to convert numbers to text with the Excel using TEXT Function. If you have any queries/suggestions, kindly drop it in the below comment box. Thanks for visiting Geek Excel!! Keep Learning!!