Text Import Wizard, Step 3.
In the wizard's third and final step, you can make formatting changes if necessary. Excel automatically formats each column as General. Numeric values are converted to numbers, date values are converted to dates, and all remaining values are converted to text.
You can make changes to the format of columns by selecting a column and then selecting an option under Column data format. For example, if there's a column of part numbers that you want to define as text instead of numbers, select the Text option.
You can also skip a column instead of importing it by selecting the Do not import column option. You'll see how to do this in the practice at the end of the lesson.
