Convert exponential to Value

[abhaysingh]

Hi,

How to convert exponential value to number pls suggest.

Pls find the attached sample data.

[manojkulkarni]

check the link

Convert Exponential values in Numbers??? | Qlik Community

[Chanty4u]

chk dis

convert exponential number to decimal

[abhaysingh]

no luck

[jagan · Accepted solution]

Hi,

Try like this

LOAD

     Num(Replace(@1, ',', '.'), '(dec)') AS Formatted_Decimal

FROM

[exponential fig.xls]

(biff, no labels, table is Sheet1$);

Regards,

jagan.

[jonathandienst]

The problem appears to be the , decimal. This works:

     LOAD Num(Replace(@1, ',', '.')) As Value

     FROM [exponential fig.xls]

     (biff, no labels, table is Sheet1$);

EDIT: beaten to it by Jagan