Format a column in Excel. 1. Open the destination Excel workbook and then display the worksheet that contains the exported data. 2. Right-click a column or a selected range of cells and then click Format Cells. 3. On the Number tab, under Categories, select a format, such as Text, Number, Date or Time. 4. Click ok.