alphanumeric formatting in QlikView

[Krish]

Hi All,

 I have a column from an excel source which looks like below.

Col1	Col2
8.70773E+11	Deesc1
01598705SKY2SUW	Desc2

And I want the output to look like below.  I tried using Num and Text functions in load script, but it does not seem to work. How to fix this issue?

Col1	Col2
87077286047333	Deesc1
01598705SKY2SUW	Desc2