Question

How can you enter numbers as text in a cell?​

Answer 1

1)Select the cell or range of cells that contains the numbers that you want to format as text. How to select cells or a range.

Tip: You can also select empty cells, and then enter numbers after you format the cells as text. Those numbers will be formatted as text.

2)On the Home tab, in the Number group, click the arrow next to the Number Format box, and then click Text.

Note: If you don't see the Text option, use the scroll bar to scroll to the end of the list.