- Highlight the cell, cells, or column to be changed.
- Select Format, Cells (or Columns) from the menu bar.
- On the Number tab, select the appropriate format such as Text, Number, Currency, or Date.
- Click OK.
You can also format a field as text by entering an apostrophe in the cell before the information the cell, e.g. if 123 is in the cell, enter '123.