convert exponential number to decimal

[Anonymous]

variation field exponential number to decimal converting: 2.5332 e-007

[maxgro]

=

num(

Left(replace('2.5332 e-007', ' ', ''), Index(replace('2.5332 e-007', ' ', ''), 'e') -1)

* Pow(10, TextBetween(replace('2.5332 e-007', ' ', ''), 'e', ''))

, '#,##0.0000000000')

replace '2.5332 e-007' with your field

also have a look at this

How to convert an exponential no to decimal

[MarcoWedel]

Hi,

you could also try like:

hope this helps

regards

Marco

[MarcoWedel]

or in the script like:

LOAD *,
     Num(number, '(dec)') as numberDecimal
INLINE [
    number
    1.5639e-003
    2.5332e-007
    9.6548e-005
    4.7657e-009
    1.5639e003
    2.5332e007
    9.6548e005
    4.7657e009
];

hope this helps also

regards

Marco

[maxgro]

where do you find (dec)?

EDIT: found, in online help