Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to convert exponential value to number pls suggest.
Pls find the attached sample data.
Hi,
Try like this
LOAD
Num(Replace(@1, ',', '.'), '(dec)') AS Formatted_Decimal
FROM
[exponential fig.xls]
(biff, no labels, table is Sheet1$);
Regards,
jagan.
no luck
Hi,
Try like this
LOAD
Num(Replace(@1, ',', '.'), '(dec)') AS Formatted_Decimal
FROM
[exponential fig.xls]
(biff, no labels, table is Sheet1$);
Regards,
jagan.
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