• 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.