https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238937#M89684 <HTML><HEAD></HEAD><BODY><P>You could use the text([FieldName) to force your invoice numbers to be text values. When you export to excel, the leading zeros will be maintained.</P><P>Nimish</P></BODY></HTML> Sun, 01 Aug 2010 06:32:30 GMT 2010-08-01T06:32:30Z https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238935#M89682 <HTML><HEAD></HEAD><BODY><P style="margin: 0in 0in 10pt;">Hello -</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">When users export to Excel, the leading zero's in a numbers get truncated. Any idea of how to adjust this so it does not happen? An example would be an invoice number in QlikView - 000456789, Excel 456789.</P><P style="margin: 0in 0in 10pt;">Cheers!</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">Chad</P></BODY></HTML> Fri, 30 Jul 2010 22:33:39 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238935#M89682 2010-07-30T22:33:39Z https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238936#M89683 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>While exporting, it exports Invoice number as number and hence removes leading zeroes.</P><P>I don't know how to restrict such export but...</P><P>If you want them, you can do it in excel in a very simple manner.</P><P>Select complete column of Invoice Number, go to format cells- Number format-Custom and write maximum number of leading zeroes possible in individual invoice number.</P><P>You will get what you want.</P><P>Happy Thoughts</P></BODY></HTML> Sat, 31 Jul 2010 08:18:14 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238936#M89683 2010-07-31T08:18:14Z https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238937#M89684 <HTML><HEAD></HEAD><BODY><P>You could use the text([FieldName) to force your invoice numbers to be text values. When you export to excel, the leading zeros will be maintained.</P><P>Nimish</P></BODY></HTML> Sun, 01 Aug 2010 06:32:30 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238937#M89684 2010-08-01T06:32:30Z https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238938#M89685 <HTML><HEAD></HEAD><BODY><P>its the common issues we have while exporting try like this </P><P>*Convert the number format to text like Text(field_name)</P></BODY></HTML> Fri, 24 Jun 2016 06:08:04 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238938#M89685 avinashelite 2016-06-24T06:08:04Z https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238939#M89686 <HTML><HEAD></HEAD><BODY><P>I tried your advise but is not working, should be something with excel that convert the text(field) in number</P></BODY></HTML> Thu, 22 Dec 2016 18:47:50 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel-Leading-zeros-get-removed-in-numbers/m-p/238939#M89686 hectorgarcia 2016-12-22T18:47:50Z