Excel has a nasty habit of stripping out leading zeros from your data because when it sees something that looks like it might be a number – it wants to use it that way.
This can be a real problem if you are working with things like account ids, or US Postal codes.
When you are importing into QlikView – here is a simple trick you can use to force it to be interpreted as a string and not a number:
Tack a null string on to the beginning of the field.
'' & numericfield1 as numericfield1,
Nice and simple, or was that quick and dirty?