Format numbers as text

Format cells as text

1. Select the cells you want to format.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Text, and then click OK.
4. Enter the numbers in the formatted cells.

Format existing numbers as text

If you've already entered the numbers, you can change the numbers to text data.

1. Select the cells that contain the numbers you want to format as text.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Text, and then click OK.