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: Right click on the column that you have selected. Left click on "Format Cells..." Under "Category:" Select "Special" then select "Zip Code": Click "OK". Save the file as a CSV