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

    Data export

    Hardik Gandhi



      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.