How to Convert Number to Text in Excel?

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will explain how to
– Convert numbers to text in Excel.
– Use an apostrophe to keep leading zeros.
– Use the TEXT function to deal with numbers having different formats.
– Apply the Format Cells feature to precisely change the number formatting to text.
– Use the Text to Columns option for more flexibility.
– Convert the numbers into words with VBA.
– Use the VLOOKUP function to avoid the error for different formats.

Excel won’t keep leading zeros in numbers. But let’s say you need to keep the same length for all numbers to understand the data easily. Or, say you are preserving phone numbers, ZIP codes, any kind of numeric codes, or SSNs. Then you must convert the numbers into text for leading zeros.

When you are working with currency terms, then you must use the words format of the numeric values to avoid mistakes. Using the text format of a number makes them easier to read, especially when there is no need to do calculations.

Excel Convert Number to Text

Here, we have used Microsoft 365 to prepare this article. However, you can do the same for other versions also.

Download Practice Workbook

How to Convert Number to Text in Excel? (4 Suitable Methods)

Excel offers various techniques and functions for the conversion of numeric values to text values. Here, we will discuss four suitable methods for converting numbers to text in Excel. They are:

  • Using the TEXT function.
  • Applying Apostrophe.
  • Use of Format Cells feature.
  • Using the Text to Column Wizard.

Whether you’re dealing with budgets, invoices, or any numerical data, you may need to convert numbers to text. Let’s see below how to deal with different situations.

1. Use of TEXT Function to Convert Number to Text

By default, the TEXT function converts any form of value to text. So, the number is not an exception. Not only that, but we can also use this function to get the text in a specific format also. Below, you can see some details about this TEXT function.

formula TEXT

  • You may need to add a leading zero or add currency, or you may need to convert the number into text with decimals. You can get all of these formats with the TEXT function.
  • Use the version formula that you need. I have attached the formulas and output below.

Using TEXT Function to Convert Number to Text

  • TEXT(C5,0) >>> To get only integer numbers.
  • TEXT(C6,”0″) >>> It will give the same output as above.
  • TEXT(C7,”000000″) >>> This will give you a 6-digit number, if the digits are less than 6-digit then it will add the leading zeros to make it a 6-digit number.
  • TEXT(C8,”0000000″) >>> Same as the previous one but will add leading zeros to make 7-digit numbers.
  • TEXT(C9,”0.0″) >>> This will include one decimal place in text format.
  • TEXT(C10,”0.00″) >>> Add two decimal places in text format.
  • TEXT(C11,”0.000″) >>> Include three decimal places in text format.
  • TEXT(C12,”$#,###”) >>> This will give the currency format.
  • TEXT(C13,”General”) >>> Use this to get scientific notation.
  • TEXT(C14,”YYYY-MM-DD”) >>> Convert the number in date maintaining the YYYMMDD format.

Note: Generally, Excel keeps the numbers on the right side of the cell and texts on the left. So, if the cell value alignment moved to the left then your numeric values are no more in number form, they became text format.

2. Converting Number to Text with Apostrophe

In this part, we will convert the number to text with an apostrophe. Adding an apostrophe before any cell data in Excel also converts it into text. We can use this to convert a number to text as well.

  • Write an apostrophe before the number and get the text format of the number.

Converting Number to Text with Apostrophe ()

3. Use of Format Cells Feature for Converting Number to Text

Excel offers the Format Cells dialog box with a wide range of formatting options. Selecting proper options, we can use this to change numbers to text too.

  • Select the numbers >> press CTRL+1 >> so you will see the Format Cells dialog box.
  • In that dialog box >> go to the Number tab >> from Category, choose Text option >> press OK.

Use of Format Cells Feature to Convert Number to Text

  • You will get all the numbers in text format.

Getting Text format of numbers

4. Using Text to Column Wizard to Convert Number to Text

The main feature of this wizard is to split a cell into multiple columns. In the end, it wants the type of the output data. If we don’t choose to split numbers into different columns and select the data type to text, we can change them into such with the feature.

  • Select the target numbers >> from the Data tab >> click on Text to Columns.

Using Text to Columns wizard

  • Select Delimited and press Next to the Convert Text to Columns Wizard – Step 1 of 3.
  • Similarly, press Next to the Convert Text to Columns Wizard – Step 2 of 3.
Pressing Next to the Convert Text to Columns Wizard - Step 1 of 3

Click here to enlarge the image.

  • Lastly, in the Convert Text to Columns Wizard – Step 3 of 3 >> from Column data format >> select Text >> press Finish.
Choosing Text in Convert Text to Columns Wizard - Step 3 of 3

Click here to enlarge the image.

Below, I have attached the changed format of the number.

Converted numbers

How to Apply Excel VLOOKUP Function to Avoid Error of Mixing Different Formats?

The VLOOKUP function won’t return the correct value because of the mixing of text and number format. Here, our lookup value (defined ID) is in the number format and our lookup column (IDs) has text format. That’s why, if you use this VLOOKUP function directly then it couldn’t give us the result we wanted. So, we have to convert the number for getting the actual result.

How do we do that? We can use any of the methods described above within the formula, so the VLOOKUP function picks it up as a text.

  • In this case, enter the following formula.

Reformation of VLOOKUP function

Here, the TEXT function will convert the number of the D17 cell into text format. Then the VLOOKUP function will search for this text formatted D17 value within B5:E14 cells and return the corresponding value of the 3rd column (D column) as the result.

How to Convert Number to Words with Excel VBA?

Let’s say we want to change 1 into “one”, 2 into “two”, and so on. We will need to use VBA for that.

  • From your worksheet >> under the Developer tab >> click on Visual Basic >> after opening the Visual Basic Editor >> from Insert tab >> open Module.
  • Copy-paste the given VBA code into the Module.
Convert Number to Words Using VBA

Click here to enlarge the image.

Function Convert_Number_into_word_with_currency(ByVal whole_number)
Dim converted_into_dollar, converted_into_cent
my_ary = Array("", "", " Thousand ", " Million ", " Billion ", " Trillion ")
whole_number = Trim(Str(whole_number))
x_decimal = InStr(whole_number, ".")
If x_decimal > 0 Then
    converted_into_cent = get_ten(Left(Mid(whole_number, x_decimal + 1) & "00", 2))
    whole_number = Trim(Left(whole_number, x_decimal - 1))
End If
xIndex = 1
Do While whole_number <> ""
    xHundred = ""
    xValue = Right(whole_number, 3)
    If Val(xValue) <> 0 Then
        xValue = Right("000" & xValue, 3)
        If Mid(xValue, 1, 1) <> "0" Then
            xHundred = get_digit(Mid(xValue, 1, 1)) & " Hundred "
        End If
        If Mid(xValue, 2, 1) <> "0" Then
            xHundred = xHundred & get_ten(Mid(xValue, 2))
            xHundred = xHundred & get_digit(Mid(xValue, 3))
        End If
    End If
    If xHundred <> "" Then
        converted_into_dollar = xHundred & my_ary(xIndex) & Dollar
    End If
    If Len(whole_number) > 3 Then
        whole_number = Left(whole_number, Len(whole_number) - 3)
        whole_number = ""
    End If
    xIndex = xIndex + 1
Select Case converted_into_dollar
    Case ""
        converted_into_dollar = " Zero Dollar"
    Case "One"
        converted_into_dollar = " One Dollar"
    Case Else
        converted_into_dollar = converted_into_dollar & "Dollars"
End Select
Select Case converted_into_cent
    Case ""
        converted_into_cent = " and Zero Cent"
    Case "One"
        converted_into_cent = " and One Cent"
    Case Else
        converted_into_cent = " and " & converted_into_cent & "Cents"
End Select
Convert_Number_into_word_with_currency = converted_into_dollar & converted_into_cent
End Function
Function get_ten(pTens)
Dim my_output As String
my_output = ""
If Val(Left(pTens, 1)) = 1 Then
    Select Case Val(pTens)
        Case 10: my_output = "Ten"
        Case 11: my_output = "Eleven"
        Case 12: my_output = "Twelve"
        Case 13: my_output = "Thirteen"
        Case 14: my_output = "Fourteen"
        Case 15: my_output = "Fifteen"
        Case 16: my_output = "Sixteen"
        Case 17: my_output = "Seventeen"
        Case 18: my_output = "Eighteen"
        Case 19: my_output = "Nineteen"
        Case Else
    End Select
Select Case Val(Left(pTens, 1))
    Case 2: my_output = "Twenty "
    Case 3: my_output = "Thirty "
    Case 4: my_output = "Forty "
    Case 5: my_output = "Fifty "
    Case 6: my_output = "Sixty "
    Case 7: my_output = "Seventy "
    Case 8: my_output = "Eighty "
    Case 9: my_output = "Ninety "
    Case Else
End Select
my_output = my_output & get_digit(Right(pTens, 1))
End If
get_ten = my_output
End Function
Function get_digit(pDigit)
Select Case Val(pDigit)
    Case 1: get_digit = "One"
    Case 2: get_digit = "Two"
    Case 3: get_digit = "Three"
    Case 4: get_digit = "Four"
    Case 5: get_digit = "Five"
    Case 6: get_digit = "Six"
    Case 7: get_digit = "Seven"
    Case 8: get_digit = "Eight"
    Case 9: get_digit = "Nine"
    Case Else: get_digit = ""
End Select
End Function

Using Created Function by VBA Code

  • Now, save the code >> go back to the worksheet >> in D5 cell >> use the created VBA function.
  • Press ENTER.

Practice Section

Now you can practice by yourself.


Frequently Asked Questions

1. How do I convert numbers to text in Excel without formatting?

You can use the TEXT function for conversion numbers to texts. Say, you have a number in the A1 cell. Then use the following formula: =TEXT(A1,0).

2. How to convert a formula to value in Excel without the Paste Special?

To convert a formula to value, press F2 >> then press F9 >> then click ENTER.

3. What is the fastest way to convert numbers to text in Excel?

Using an apostrophe before the number is the fastest way to convert numbers to text in Excel.


I hope all your confusion on how to convert a number to text or words in Excel is now clear now. Here, I have explained some different ways to convert the numbers into text. So, you can work with your preferred one. We have covered using an apostrophe, TEXT function, Format Cells, and Text to Column features for that. Still, if you have any queries then don’t hesitate. Feel free to communicate with us through comments or email. You can visit our site for more Excel-related articles.

Excel Convert Number to Text: Knowledge Hub

<< Go Back to Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.


Musiha Mahfuza Mukta
Musiha Mahfuza Mukta

Musiha Mahfuza Mukta is a marine engineer who loves exploring Excel and VBA programming. To her, programming is a time-saving tool for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B.Sc in Naval Architecture & Marine Engineering from BUET, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively focused on Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF