How to convert values like this (3.55e-06) into number ?

[prahlad_infy]

Hello Sirs ,

How to convert values like this (3.55e-06) into number ? ..

I tried fabs,num,num# with no result ...

Thank you all Sirs

[YoussefBelloum]

Hi,

would you be able to make an extract from the column and attach it here to make some tests ?

[Miguel_Angel_Baeyens]

You can try adding a mask to specify the format like

=Num(3.55e-06,'0.00000000')

Every 0 means a position, even if it is a "0"

[vamsee]

Adding to mbaeyens‌ suggestion try

= If( WildMatch('3.55e-06','*e-*','*E+*'), Num(Num#('3.55e-06'),'######.##########'),

'3.55e-06')

Replace 3.55e-06 with your column name.

[MarcoWedel]

depends on your definition of "number" as 3.55e-06 actually is one (in exponential notation).

If you just want to convert to decimal then maybe something like

Num(number,'(dec)') as number

might do the trick?

hope this helps

regards

Marco