Formatting a Zip Code

Excel - Formatting and Reports

To format a Zip Code, select the cells, then right-click and choose Format Cells. In the Format Cells dialog box, select Special in the Category list, then select either the Zip Code or Zip Code + 4 format and choose Ok.

Share the power...