Step 1

Highlight entire column and right click. Choose Format Cells.

Step 2

Click on Custom.

Step 3

For zip code: Input 5 zeros
For zip extension: Input 4 zeros
For SSN: Input 9 zeros

Step 4

Click OK and upload the file.