How to display values as text in Excel:
- Select the cells that contain the values you want to display as text.
- Right-click on the selected cells and choose "Format Cells" from the context menu.
- In the Format Cells dialog box, click on the "Number" tab.
- In the Category list, select "Text".
- Click "OK" to apply the changes.
Note: If you want to apply this formatting to an entire column or range of cells, you can select the column or range before following the above steps.