zlacker

>>voxada+(OP)
There are many problems with zip codes / postal codes but the biggest two we see are:

a. Excel treats them as numbers instead of strings of digits and thus drops the leading 0

b. Developers make assumptions about postal codes based on how they work (or more usually how the developer incorrectly thinks they work) in their own country and these assumptions absolutely do NOT hold in other countries.

A relevant guide to geocoding and postal codes: https://opencagedata.com/guides/how-to-think-about-postcodes...

>>freyfo+AB
The post office has adapted in turn to that Excel problem. They know it happens. If a parcel has only four digits for the zip code, they'll treat it as a leading zero for routing and delivery.