Question

To format the text, you will click the
tab in format cells box.
(a) Alignment
(b) Fill
(c) Numberto format the text you click the dash type in format cells box ​

Answer 1

To avoid this from happening, change the cell type to Text:

Open the Excel workbook.

Click on the column heading to select entire column.

Click Format > Cells.

Click the Number tab.

Select “Text” from the Category list.

Click OK.