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/.
0 comments:
Post a Comment