2 Replies Latest reply: Oct 16, 2012 1:28 PM by Hardik Gandhi RSS

    Data export

    Hardik Gandhi

      Hi,

       

      When I am exporting my data to excel 2007 I am having issue with Customer ID field.

       

      Its a nine digit field usally starting with '0' i.e. 079829909

       

      Once I export it to excel its not preserving the leading zero i.e 79829909.

       

      Usally to over come this I convert the field to Text so that it holds the leading zero.

       

      Please advise the best option to avoid such scenarios while exporting data.

       

      Regards,

      H