Excel - CrossTable - Problem of Loading of percentage values with decimals

[#1]

I have a xls file where I have in column an allocation percentage that is stored in xls with a decimal - 2.5% - but displayed without - 3% -. When I load this file in QlikView, I have the value 0.03000 while I would like to obtain 0.02500.

The instruction to load the file is

Crosstable (Week_Text, Allocation, 2)

Load Employee, Project,

[40550], [40557], [40564], .......

from ....

Any suggestion ?

Thank you,

JM

[pover]

What happens if you load the file without the crosstable?

Regards.

[#3]

You are right ! Nothing to do with the crosstable ! I also remove the Percentage format in xls ! If we have a value 111.2 and you do not dispay the decimals in xls - 111 -, they are not loaded.

Thanks for your help