topic Re: Number format in QlikView https://community.qlik.com/t5/QlikView/Number-format/m-p/416794#M1156902 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> Try like this</P><P>Num() function or num#() function.</P></BODY></HTML> Fri, 11 Jan 2013 21:56:56 GMT MayilVahanan 2013-01-11T21:56:56Z Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/416792#M1156900 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a field which is numeric in nature. When I am loading the field from excel spreadsheet, Qlikview is adding leading 0 ( zero) in front of the number. I don't want these 0's to be added in the front. For eg: the field CYCM has a value of 85168. When loaded in Qlikview, it shows as 0000000085168.</P><P></P><P>How can I restrict Qlikview to show it as 85168 after loading in QVW without the 0's during load time. I can change the number settings in the list box, but I don't want to go there. Want to load it as is.</P><P></P><P>All your help will be appreciated.</P><P></P><P>Thanks,</P><P>Tutan</P></BODY></HTML> Fri, 11 Jan 2013 21:54:10 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/416792#M1156900 2013-01-11T21:54:10Z Re: Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/416793#M1156901 <HTML><HEAD></HEAD><BODY><P>Did you checked with simply Num(FieldName)?</P><P>It looks like it loads as a Text not as a number.</P></BODY></HTML> Fri, 11 Jan 2013 21:56:55 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/416793#M1156901 CELAMBARASAN 2013-01-11T21:56:55Z Re: Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/416794#M1156902 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> Try like this</P><P>Num() function or num#() function.</P></BODY></HTML> Fri, 11 Jan 2013 21:56:56 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/416794#M1156902 MayilVahanan 2013-01-11T21:56:56Z