You can format the number in an expression when you use the field like this:
Num( BigNumber , '000000000000000' )
Anyhow what you see in QlikView is just another way of displaying large numbers using scientific notation. This is the way Excel displays big numbers like this by default. So your Excel sheet has been set up to format them with the maximum number of digits instead of using scientific notation. You can do exactly this also with QlikView - just as I illustrated above - in many places. Either in the Load Script or in the user interface or the expressions being used.
If you are showing these values in any chart .Play with Number tab options in chart properties.You will get desired result. After applying the properties in chart if you still get the same output drag the column to right.
