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

  • Profile Image
    ultramarcas
    Asked 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
    jonathan
    Answered 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.