topic Re: qlik recognizing numbers as dates from excel in QlikView https://community.qlik.com/t5/QlikView/qlik-recognizing-numbers-as-dates-from-excel/m-p/1218068#M389813 <HTML><HEAD></HEAD><BODY><P>Hi Jean ,</P><P></P><P>Try like below, </P><P></P><P>Num(<SPAN style="font-size: 13.3333px;"><STRONG>FieldName</STRONG></SPAN>) as FieldName</P></BODY></HTML> Wed, 07 Dec 2016 07:31:45 GMT tamilarasu 2016-12-07T07:31:45Z qlik recognizing numbers as dates from excel https://community.qlik.com/t5/QlikView/qlik-recognizing-numbers-as-dates-from-excel/m-p/1218066#M389811 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>My excel file&nbsp; has one number field which is being recognized as date while loading in qlik.</P><P>How to make sure that number comes as number an not as date?</P><P>Regards,</P><P>Jean</P></BODY></HTML> Wed, 07 Dec 2016 07:28:10 GMT https://community.qlik.com/t5/QlikView/qlik-recognizing-numbers-as-dates-from-excel/m-p/1218066#M389811 jduluc12 2016-12-07T07:28:10Z Re: qlik recognizing numbers as dates from excel https://community.qlik.com/t5/QlikView/qlik-recognizing-numbers-as-dates-from-excel/m-p/1218067#M389812 <HTML><HEAD></HEAD><BODY><P>Try num(Num#(Yourfield)) in load script</P></BODY></HTML> Wed, 07 Dec 2016 07:31:42 GMT https://community.qlik.com/t5/QlikView/qlik-recognizing-numbers-as-dates-from-excel/m-p/1218067#M389812 Anonymous 2016-12-07T07:31:42Z Re: qlik recognizing numbers as dates from excel https://community.qlik.com/t5/QlikView/qlik-recognizing-numbers-as-dates-from-excel/m-p/1218068#M389813 <HTML><HEAD></HEAD><BODY><P>Hi Jean ,</P><P></P><P>Try like below, </P><P></P><P>Num(<SPAN style="font-size: 13.3333px;"><STRONG>FieldName</STRONG></SPAN>) as FieldName</P></BODY></HTML> Wed, 07 Dec 2016 07:31:45 GMT https://community.qlik.com/t5/QlikView/qlik-recognizing-numbers-as-dates-from-excel/m-p/1218068#M389813 tamilarasu 2016-12-07T07:31:45Z