topic Re: data sending to excel in QlikView https://community.qlik.com/t5/QlikView/data-sending-to-excel/m-p/110929#M17311 <HTML><HEAD></HEAD><BODY><P>you may define a Format under Settings/Document/numbers</P><P>Format your field Sales ID to</P><P></P><P>###0000000000000 </P></BODY></HTML> Wed, 26 Sep 2018 13:01:24 GMT Anonymous 2018-09-26T13:01:24Z data sending to excel https://community.qlik.com/t5/QlikView/data-sending-to-excel/m-p/110928#M17310 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a field called Sales ID&nbsp; having 13 digit values like</P><P></P><P>0103011800204</P><P>0103021800205</P><P></P><P>while exporting to excel missing zeros and getting values like this</P><P style="font-size: 13.3333px;">103011800204</P><P style="font-size: 13.3333px;">103021800205</P><P></P><P>so how to get with zeros as well. can anyone help thanks</P><P></P><P>Regards,</P><P>Nagarjuna.</P></BODY></HTML> Wed, 26 Sep 2018 12:56:25 GMT https://community.qlik.com/t5/QlikView/data-sending-to-excel/m-p/110928#M17310 nagarjuna005 2018-09-26T12:56:25Z Re: data sending to excel https://community.qlik.com/t5/QlikView/data-sending-to-excel/m-p/110929#M17311 <HTML><HEAD></HEAD><BODY><P>you may define a Format under Settings/Document/numbers</P><P>Format your field Sales ID to</P><P></P><P>###0000000000000 </P></BODY></HTML> Wed, 26 Sep 2018 13:01:24 GMT https://community.qlik.com/t5/QlikView/data-sending-to-excel/m-p/110929#M17311 Anonymous 2018-09-26T13:01:24Z Re: data sending to excel https://community.qlik.com/t5/QlikView/data-sending-to-excel/m-p/110930#M17312 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have tried its not working</P></BODY></HTML> Wed, 26 Sep 2018 13:21:57 GMT https://community.qlik.com/t5/QlikView/data-sending-to-excel/m-p/110930#M17312 nagarjuna005 2018-09-26T13:21:57Z