To Specify Formatting for Extracted Data in a Column

1. Click Insert tab Linking & Extraction panel Extract Data. Find
2. 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.
3. In the Set Cell Format dialog box, select the data type from the Data Type list.
4. Depending on the selected data type, additional options are available on the right side of the dialog box.