Zipcodes in Upload File

Christopher Bingham -


  1. Sort the column with zipcodes and select only the cells that include zip codes with 9 digits without a dash between the zip and remaining 4 numbers. (Tip: do not select the ones that are 5 digit zipcodes)

  2. On the Home tab, next to Number in the Number Format box  Format Number box , click the arrow, and then click More Number Formats.                                      mceclip2.png

  3. In the Format Cells dialog box, under Category, click Special.

  4. In the Type box, select Zip Code + 4

  5. Click OK
  6. Save excel and upload students


Have more questions? Submit a request


Please sign in to leave a comment.