Boston has leading zeros for its ZIP codes.
Google Sheets is very helpful in removing leading zeros but unfortunately it removes them from Boston ZIP codes.
I tried to find a number format for address ZIP codes but couldn't find one. I also tried to find a number format that preserves leading zeros but couldn't figure it out.
How can I prevent Google Sheets from removing the leading zero in ZIP codes?
Format>Number>Plain Text works great to allow leading zeros.
To restore the leading zeros if they are gone without having to add them manually, I found this article.
Basically you can use a formula to check the length of your zip code column. If the length is 4, it adds a leading 0.
The formula (assuming your zip code is in column B):
Make sure to format the resulting column as plain text as well.
You can also just put an apostrophe in front of the zip codes like
Or select the column / cells that will contain the zip codes and set to the following as listed above
Format -> Number -> Plain Text
00000 in the entry box.
Click the the Apply button.