To Specify Formatting for Extracted Data in a Column

Click Insert tab Linking & Extraction panel Extract Data. Find
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.

Was this information helpful?

Yes
No