Resource Center Home

ACA Resources

Formatting Excel Documents for Leading Zeros

You are here:
Estimated reading time: 2 min

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.

Was this article helpful?
Dislike 0
Views: 11