What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Zero, is supressed in Excel report. How to solve it?

    Asked by ultramarcas on November 22, 2012 at 05:18 PM

    Hello!

     

    In my form there is a field called "CNPJ", where the input data are like this (14 caracters): E.g: "01234567000101".

    When I export for XLS or CSV, the Excel hides the "0" (zero), entered at the begin of the sequence of numbers.

     

    I tried to setting up the cell properties of "CNPJ" at the Excel for "Number", but the zero was supressed.

     

    How can I resolve it?

  • Profile Image
    JotForm Support

    Answered by jonathan on November 22, 2012 at 05:31 PM

    Hi,

    If it start with zero(0), Excel will suppress it because it is not considered a number by excel. Try to make it a text type instead. Try format command to that particular column in excel, and set it to text or general..

    If it still does not work, try appending an apostrophe(') at the start of the value -- i.e. '01234567000101 

    Please try this. Inform us if this does not make the difference.

    Thanks.