Hi. When I download submission to CVS / Excell all key in numbers start

  • Profile Image
    Bang Apit
    Asked on December 15, 2021 at 11:43 AM

    Hi. When I download submission to CVS / Excell all key in numbers starting with 0 (zero) disappear ..



    This is a re-post of a comment on How to Download Form Submissions as Excel, CSV, or PDF

  • Profile Image
    Parker
    Answered on December 15, 2021 at 12:45 PM

    Hello,

    Can you share which form it is you are doing this on so we can look at how things are setup. I made a test form and downloaded to Excel and it depends on the type that you use as Excel will strip a leading 0 off if it's a number field but a text string the 0 is fine to have.

    Both values entered were 012 but the short text field which has a string instead of a number will keep the 0 in front.

    1639590234_61ba295a62426_

  • Profile Image
    ujiantasmie
    Answered on December 16, 2021 at 01:22 AM
    ok thanks .. the problem fixed... it's cause by excell.
    So on excell sheet .. me just proceed format all cells with "o"# ... then
    zero (o) appear
    ...