Exporting text to Excel Report that contains leading zeros

  • Profile Image
    Asked on March 25, 2013 at 05:39 AM

    I have some text fields that can contain alphanumeric values including preceding zeroes such as for example "05".  They are accepted in the form and also sent correctly in the submission and confirmation emails but are exported to the worksheet with the leading zeros missing. 

    Is there any way of working around this problems.

  • Profile Image
    Answered on March 25, 2013 at 11:31 AM

    Hi there, 

    You can edit the column formatting options on the spreadsheet.  In stead of having them formatted as nuimbers, simply choose the text option and see if that solves the issue.

    Unfortunately, on the builder there would be nothing we can do to prevent the spreadsheet stripping out the leading 0s.