Include Lead Zero in ZIP Codes
Please see attached image. When exporting to Excel CSW, is it possible to include the lead zero in ZIP codes that begin with a zero (i.e.. Boston, MA)?
-
Jason Godin
- Mar 13 2020
- Already exists
-
Mar 20, 2020
Admin response
Great question there Jason!
In Excel, change the formatting of the postal code column to "Text". This will stop Excel from dropping the leading zero:
Keep the ideas coming as they're how we create a better solution for everyone!
Related ideas
