I created a custom field for ‘zip code’ with the field type # Number. When I import zip codes that start with ‘0’ the 0 is automatically removed and only 4 digits display. For example the zip code 05405 displays as 5405 which is incorrect. Other than creating a new zip code custom field type A text, is there a way to retain the ‘0’ at the start of a zip code? (I tried using Excel step of adding a ’ before the 0 but it doesn’t work).
Arf that’s a developer thing, a number does not start with zero. You should use a text field.
2 Likes