Loading Scientific values from excel

[qlik_aparna]

Hi All,

I am currently loading scientific values from excel using text(Field). But only for field value 3.50E+113 it's removing the 0 in the value and it's loading as 3.5E+113. Any workaround for this? I want the values as the same in excel.

8.94E+113

3.50E+113

6.29E+112

2.82E+112

8.76E+110

[StarinieriG]

Hi,

try with this:

Evaluate(Num#(PurgeChar(Num(Subfield(A,'E+',1),'#.##0,00'),',') & Repeat('0',Subfield(A,'E+',2)-2),'#.##0')) 

[qlik_aparna]

It's still not working. The 0 in the value is missing

[StarinieriG]

File attached