There are roughly 3443 US zip codes with a leading zero, 230 with two leading zeros.
If a zip code is given
conditional formatting(five zeros) in GS, the data editor displays 4 digits (shaves the 0)
If the zip code column is formatted as
plain textbefore data is entered, the data editor displays all 5 digits.
Using a number entry field
- If no value is in that cell, and a zip code with a leading zero is entered:
– Initially you get 5 digits in preview, 4 digits in data editor, 4 digits in Sheets.
– On sync, you’ll get 4 digits across the board.
Using a text entry field
Leading zeros are preserved across preview, data editor, and GS; but text characters can be inadvertently entered.
This is not a quirk suitable for a template column fix…