Jotform export converteert nummers naar tekst?

  • Pouw_Groep
    Gevraagd op 21 februari 2024 om 03:20

    Het betreft dit jotformulier: https://form.jotform.com/Pouw_Groep/2023-pouw-vervoer-schademeldings-ap

    Sinds vorige week is de export van onderstaande numerieke velden naar tekst veranderd bij de export naar xls.

    • Chauffeursnummer
    • Busnummer

    Graag jullie reactie.


  • Mary Jotform Support
    Geantwoord op 21 februari 2024 om 06:07

    Hi Pouw_Groep,

    Thanks for reaching out to Jotform Support. Unfortunately, our Dutch Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Dutch, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. I checked, and it seems that this is the normal behavior. The numbers are being converted to a text field when downloading it as an Excel file. I would suggest converting the data into numbers.

    You can change the cell type to number easily by selecting the cell, click on the arrow and select 'Convert to Number'.

    Jotform export converteert nummers naar tekst? Image 1 Screenshot 30

    To change multiple cells type at once, hold SHIFT and select the rows you want to change type for. Repeat the steps.

    Jotform export converteert nummers naar tekst? Image 2 Screenshot 41

    Give it a try and let us know if you have any other questions.