Num Function not working

[zain16nib]

Hi,

C_1	GL_AVG_BAL	GL_AVG_YTD
1.4E-5	1.5E-5	1.5E-5

how to convert in number format. result is

0.0000144        0.0000145548387096774   0.0000145548387096774

I am trying  num(C_1,'#,##0.################')/1000000 in script  but no effect. 

Regards,

Zain.

[Channa]

show 2 decimals after

why u divining decimal values by million

[zain16nib]

thanks for reply, i got solution num(C_1,'(dec)')

Regards,

Zain.