Importing 4 Digit Zip Codes How to format 4 digit zip codes so that you can import them to Send Jim Select the entire Zip code column: 2. Right click on the column that you have selected. 3. Left click on "Format Cells..." 4. Under "Category:" Select "Special" then select "Zip Code": 5. Click "OK".6. Save the file as a CSV