• Handling Large Numbers: Excel's 15-digit precision limit can cause rounding issues for long numbers like credit card numbers. Converting to text prevents inaccuracies for numbers over 15 digits.
• Preserving Leading Zeros: Excel removes leading zeros by default. Converting to text is crucial for maintaining zeros in product codes, zip codes, and similar identifiers.
• Preventing Automatic Date Formatting: Excel automatically changes number sequences resembling dates (e.g., "01-01") into dates. Text conversion is needed to keep the original format.
• Partial Number Searches: For finding specific sequences within numbers (like finding "10" in "101", "1110"), using text format is necessary since standard number formats may not support such searches.
• Consistency in Data Matching: Functions like VLOOKUP or MATCH require consistent data formats. Converting to text helps match data accurately, especially when dealing with formats that include leading zeros.

Given these scenarios, it's clear that converting numbers to text in Excel can be crucial for maintaining data accuracy, ensuring effective searches, and preventing unwanted automatic formatting. This tutorial will guide you through various methods to achieve this conversion, catering to different needs and data types.

• Change number to text in Excel
  • Using Format Cells command (Ideal for large datasets; simple conversion)
  • Using Kutools for Excel (Extensive toolkit; perfect for multifaceted data manipulation)
  • Using TEXT function (Best for custom formatting; advanced needs)
  • By adding an apostrophe (Simple for a few numbers; quick manual fix)
  • Using Text to Columns wizard (Useful for single columns; not for multiple columns)
• Tip 1: Convert numbers stored as text to numbers
• Tip 2: Convert numbers to English words

Video: Change or convert number to text in Excel

Convert number to text with Format Cells command

Microsoft Excel's Format Cells command is a straightforward method for changing number formats. It's particularly useful when you need to convert large ranges of numbers to text without altering their appearance.

1. Select the numbers that you want to convert to text.
   Tip: You can first format empty cells as text before entering numbers. This ensures numbers entering afterwards are treated as text, especially useful for adding leading zeros.
2. On the Home tab, click the down arrow in the Number group, and choose Text.

   

Result

The selected numbers are converted to text immediately.

Change numbers to text with Kutools for Excel

Kutools for Excel offers an advanced toolkit to streamline complex Excel conversion tasks as shown in the screenshot below, including number-to-text conversion. If you have Kutools installed, please apply its Convert between Text and Number tool as follows:

1. Select one or more ranges with numbers that you want to change to text.
2. Click Kutools > Content > Convert between Text and Number.

   

   Tip: If the utility isn't visible in the Content drop-down list, look for it in the Conversion drop-down list.
3. In the Convert between Text and Number dialog box, select the Number to text option, and click OK. This will convert all numbers to text within the original range, as illustrated below.

   

   Tips:

   • You can easily identify if a number is formatted as text by its left alignment in the cell, in contrast to standard numbers which align to the right.
   • Also, a small triangle appearing in the top-left corner of each selected cell indicates that these cells now contain the text versions of the numbers.

Change number to text with TEXT function

While the forementioned methods are straightforward for basic number-to-text conversions, the TEXT function in Excel offers a higher level of customization and control. This function is particularly useful when you need to convert numbers to text with specific formatting requirements.

For instance, if you're looking to display numbers in a particular currency format, maintain a certain number of decimal places, or adhere to other custom numeric formats, the TEXT function is your go-to solution. It allows you to define the exact format of the output text, making the TEXT function an ideal choice for situations requiring precision and personalized formatting in your data presentation.

• To convert the numbers to text with at least one digit and no decimal places, use this formula:

  =TEXT(A2,"0")

• To convert the numbers to text with at least two digits and exactly 1 decimal place, use this formula:

  =TEXT(A7,"00.0")

• To convert the numbers to text while keeping their original formatting, use this formula:

  =TEXT(A12,"General")

  Note: Should you use the above formula on a system with non-English language settings and encounter a #VALUE error, you may need to consider using the following alternative formula:

  =""&A12

  

Change number to text by adding an apostrophe

Adding an apostrophe before a number is a quick and manual method ideal for conversions of single numbers to text format, particularly useful when you need to convert just 2 or 3 numbers to text.

To do this, simply double click on a cell, and enter an apostrophe (') before the number in the cell.

Convert numbers to text using Text to Columns wizard

Text to Columns, a versatile tool in Excel for data manipulation, can efficiently convert a column of numbers to text. It's an ideal choice for handling number-to-text conversions within a single column.

1. Select the numbers you wish to convert to text.
2. On the Data tab, in the Data Tools group, choose Text to Columns.

   

3. In the pop-up Convert Text To Columns Wizard, skip steps 1 and 2 by clicking on the Next button. On the third step of the wizard, select the Text radio button, and click Finish to change the numbers in the column to text.

   

   Tips:

   • You can easily identify if a number is formatted as text by its left alignment in the cell, in contrast to standard numbers which align to the right.
   • Also, a small triangle appearing in the top-left corner of each selected cell indicates that these cells now contain the text versions of the numbers.

Tip 1: Convert numbers stored as text to numbers

To convert these text-formatted numbers back to standard numeric format, so that Excel can recognize and treat them as actual numbers for any computational purposes, please view this tutorial: How to mass convert numbers stored as text to numbers in Excel?

Tip 2: Convert numbers to English words

To convert numbers to their equivalent English words or English currency words as the following screenshot shown, please view this tutorial: How to quickly convert numbers to English words in Excel?

Above is all the relevant content related to changing numbers to text in Excel. I hope you find the tutorial helpful. If you're looking to explore more Excel tips and tricks, please click here to access our extensive collection of over thousands of tutorials.

Related articles

• How to convert date stored as text to date in Excel?
• How to convert numbers to words in Indian rupees in Excel?
• How to convert time difference between two times to number (hours/minutes/seconds) in Excel?