To specify formatting for extracted data
in a column
In the Data Extraction wizard on the Refine Data page,
right-click the column label for the column that will have its data
type changed. From the shortcut menu, click Set Column Data
Format.
In the Set Cell Format dialog box, select the data type from
the Data Type list (Angle, Currency, Data, Decimal Number, General,
Percentage, Point, Text, or Whole Number.)
Depending on the selected data type, specify additional options
from the right side of the dialog box.