- Click Insert tab
Linking & Extraction panel Extract Data.
At the Command prompt, enter DATAEXTRACTION - On the Refine Data page, right-click the column label for the column that will have its data type changed. From the shortcut menu, choose Set Column Data Format.
- In the Set Cell Format dialog box, select the data type from the Data Type list.
- Depending on the selected data type, additional options are available on the right side of the dialog box.