qlik recognizing numbers as dates from excel

[jduluc12]

Hi,

My excel file  has one number field which is being recognized as date while loading in qlik.

How to make sure that number comes as number an not as date?

Regards,

Jean

[Anonymous]

Try num(Num#(Yourfield)) in load script

[tamilarasu · Accepted solution]

Hi Jean ,

Try like below,

Num(FieldName) as FieldName