topic Data export in QlikView https://community.qlik.com/t5/QlikView/Data-export/m-p/420476#M700178 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When I am exporting my data to excel 2007 I am having issue with Customer ID field. </P><P></P><P>Its a nine digit field usally starting with '0' i.e. 079829909</P><P></P><P>Once I export it to excel its not preserving the leading zero i.e 79829909.</P><P></P><P>Usally to over come this I convert the field to Text so that it holds the leading zero.</P><P></P><P>Please advise the best option to avoid such scenarios while exporting data.</P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 16 Oct 2012 17:14:57 GMT hkg_qlik 2012-10-16T17:14:57Z Data export https://community.qlik.com/t5/QlikView/Data-export/m-p/420476#M700178 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When I am exporting my data to excel 2007 I am having issue with Customer ID field. </P><P></P><P>Its a nine digit field usally starting with '0' i.e. 079829909</P><P></P><P>Once I export it to excel its not preserving the leading zero i.e 79829909.</P><P></P><P>Usally to over come this I convert the field to Text so that it holds the leading zero.</P><P></P><P>Please advise the best option to avoid such scenarios while exporting data.</P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 16 Oct 2012 17:14:57 GMT https://community.qlik.com/t5/QlikView/Data-export/m-p/420476#M700178 hkg_qlik 2012-10-16T17:14:57Z Re: Data export https://community.qlik.com/t5/QlikView/Data-export/m-p/420477#M700179 <HTML><HEAD></HEAD><BODY><P>If you really need it to be text in excel then you'll have to convert it to text. Otherwise you could simply change the formatting in excel so it shows leading zeros.</P></BODY></HTML> Tue, 16 Oct 2012 17:24:10 GMT https://community.qlik.com/t5/QlikView/Data-export/m-p/420477#M700179 Gysbert_Wassenaar 2012-10-16T17:24:10Z Re: Data export https://community.qlik.com/t5/QlikView/Data-export/m-p/420478#M700180 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Tue, 16 Oct 2012 17:28:10 GMT https://community.qlik.com/t5/QlikView/Data-export/m-p/420478#M700180 hkg_qlik 2012-10-16T17:28:10Z