...
- In the Data Preview, click on the heading of the first column - it should say "General."
(click image to enlarge)
- Scroll the bar over to the far, right side so that the last column in your data set displays.
- Hold down the Shift key on your keyboard and click the header of the last column. Release the Shift key. This should highlight all the columns.
- In Column data format, click the radio button next to Text. This will import all of the columns in text format.
(click image to enlarge)
- Click Finish
- Save the newly imported file in Excel format to the desired location on your computer, USB flash drive or network drive.