Export of ZIP/Postal Code should be text, not number

  • Resolved jabbett

    (@jabbett)


    1 year, 4 months ago

    I use the “address” field in several forms, including the “ZIP/Postal Code” sub-field within it.

    When I export the form to CSV, the ZIP code data exports as numbers, not as text — i.e. 02368 instead of "02368" — and so they get imported into Excel/Numbers/Google Sheets as numbers and lose their leading zero, e.g. 02368 appears as 2368.

    I think the most appropriate behavior for the export feature would be to enclose ZIP/Postal Codes in quotes. Thanks!

    • This topic was modified 1 year, 4 months ago by jabbett.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Williams – WPMU DEV Support

    (@wpmudev-support8)

    Hi @jabbett

    I hope you’re well today!

    I just tried to replicate this and when importing to Excel, that leading zero is not removed automatically.

    In Google Sheets it’s slightly different but you can easily avoid removing that leading zero there as well if – when importing the file – you uncheck the “Convert text to numbers, dates and formulas” checkbox:

    https://app.screencast.com/5LlcN2puLmdz9

    Kind regards,
    Adam

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @jabbett ,

    I will close this topic since you haven’t responded to Adam for some time now.

    Feel free to re-open if you have more questions.

    kind regards,
    Kasia

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Export of ZIP/Postal Code should be text, not number’ is closed to new replies.