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.
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.