Instructions for importing a tab delimited file into Excel 2000

1. In Excel, select File/Open.
2. In the Open dialogue box, go to the "Files of Type" drop down box and select "All files"
3. Navigate to the location where you saved the datafile.
4. Double click the file.
5. The Text Import Wizard will appear.
6. Select "Delimited" and click "Next".
7. Select "Tab" in the "Delimiters" window and click "Next".
8. Scroll to the Zip Code Field ("Applicant Zip Code") and highlight that column.
1. For "Column Data Format", select "Text"
9. Scroll to the 470 Application Number Field ("470 Application Number") and highlight that column.
   a. For "Column Data Format", select "Text"
   
10. Click Finish.