topic How can I format numbers so that leading zeros are preserved when exported to Excel? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-format-numbers-so-that-leading-zeros-are-preserved/m-p/187016#M50853 <HTML><HEAD></HEAD><BODY><P>I havea series of plant numbers most of which have 4 digits but some have 3 digits and 1 letter. All have 4 characters and some have 1,2 or 3 leading zeros. When exported to Excel the leading zeros are dropped except for those entries which contain a letter as they are formatted as text. For example 0010 is displayed as just 10 but with 001F the leading zeros are preserved when exported to Excel. Is there any way that all the numbers can be formatted as text or is there some other way of preserving the leading zeros when the data is exported to Excel? Any advice would be appreciated.</P></BODY></HTML> Fri, 19 Mar 2010 18:24:37 GMT 2010-03-19T18:24:37Z How can I format numbers so that leading zeros are preserved when exported to Excel? https://community.qlik.com/t5/QlikView/How-can-I-format-numbers-so-that-leading-zeros-are-preserved/m-p/187016#M50853 <HTML><HEAD></HEAD><BODY><P>I havea series of plant numbers most of which have 4 digits but some have 3 digits and 1 letter. All have 4 characters and some have 1,2 or 3 leading zeros. When exported to Excel the leading zeros are dropped except for those entries which contain a letter as they are formatted as text. For example 0010 is displayed as just 10 but with 001F the leading zeros are preserved when exported to Excel. Is there any way that all the numbers can be formatted as text or is there some other way of preserving the leading zeros when the data is exported to Excel? Any advice would be appreciated.</P></BODY></HTML> Fri, 19 Mar 2010 18:24:37 GMT https://community.qlik.com/t5/QlikView/How-can-I-format-numbers-so-that-leading-zeros-are-preserved/m-p/187016#M50853 2010-03-19T18:24:37Z How can I format numbers so that leading zeros are preserved when exported to Excel? https://community.qlik.com/t5/QlikView/How-can-I-format-numbers-so-that-leading-zeros-are-preserved/m-p/187017#M50854 <HTML><HEAD></HEAD><BODY><P>I'm having the same exact problem. Anyone find a resolution to this?</P></BODY></HTML> Mon, 22 Nov 2010 22:36:03 GMT https://community.qlik.com/t5/QlikView/How-can-I-format-numbers-so-that-leading-zeros-are-preserved/m-p/187017#M50854 2010-11-22T22:36:03Z How can I format numbers so that leading zeros are preserved when exported to Excel? https://community.qlik.com/t5/QlikView/How-can-I-format-numbers-so-that-leading-zeros-are-preserved/m-p/187018#M50855 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Take a look at <A href="http://community.qlik.com/forums/p/36953/144943.aspx" target="_blank" title="Data corruption? in Qlikview">this thread</A>, which seems to be related to what you are telling.</P><P>Use the sample code in that post. Tip: use the Text() function to represent it as string.</P><P>Hope that helps</P></BODY></HTML> Mon, 22 Nov 2010 23:12:35 GMT https://community.qlik.com/t5/QlikView/How-can-I-format-numbers-so-that-leading-zeros-are-preserved/m-p/187018#M50855 Miguel_Angel_Baeyens 2010-11-22T23:12:35Z