Instructions for Opening the Downloaded Files
as Spreadsheets
Instructions are furnished below for using Excel.
If you use another spreadsheet program, please refer to your reference manual for detailed instructions.
NOTE: Because Excel will drop the leading zeros on any numeric data unless the data is imported as 'text', be sure to follow steps 6-10 carefully.
Launch Excel
Select Open from the File menu
Locate and highlight the name of the file you want to open
Click on Open
A window titled "Text Import Wizard - Step 1 of 3" will appear.
The information in the window will begin with "The Text Wizard has determined that your data is Delimited. If this is correct, choose Next, or choose the Data Type that best describes your data."
Click on the Next button until you reach Step 3 of 3
Scroll over to and select the ZIP code column
In the Column data format box, select the Text option
Click Finish
Save your document
Click below for directions for using your Excel document to Mail Merge
with Word 2000.
If you use another version of Word, please refer to your reference manual
for detailed instructions.
