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!

  • Attach files