Add Leading Zero's to Zip Codes in Excel

Two methods to pad zip codes with 0's when they are less than 5 digits:

This changes the value of the cell:
1. =TEXT(A1,"00000")

This doesn't change the value of the cell but simply displays the number with the leading zeros:
2. Within the cell (or highlight the column) select Format > Format Cells, Number, Custom, 0000#

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.