Sometimes you may not want the numbers in the cells getting involved in calculating, or you may want to display leading zeros in numbers in cells.
If you just only want to convert the number to text without any formatting, you can use the formula: .2. And select the cell E1, drag the fill handle over the range of cells that you want to apply this formula.3.As the data is formula, you can change the formulas to values.Copy the cells and right-click where you want to paste the values and select Paste special.Select values and your values will be displayed as text as below.Microsoft Excel's Format Cells command is also able to convert numbers to text.1.
Select the numbers that you want to convert to text.2.Right click the selected range, and choose the Format Cells item from context menu. In the Format Cells dialog box, select the Text item in the Category box under Number tab, and then click the OK button.See screenshot: Then numbers in selected range are converted into text. In the Convert between Text and Number dialog box, check the Number to text option, and then click the OK or Apply button.If you have Kutools for Excel installed, it will be easier for you to convert numbers in cells to text with Convert between Text and Number. Select the range with numbers that you want to change to text.2. See screenshot: Now all numbers in selected range are converted to text in the original range.Kutools for Excel includes more than 120 handy Excel tools. See screenshots: Kutools for Excel's Convert between Text and Number tool can quickly specify a range cells or a cell in your worksheet to recognize the numbers you enter as numeric data.And it can help you convert between the numbers and numbers stored as text in cells quickly.