Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know how to convert exponents into actual numbers?
Example: it shows '3.4115809049999998E+03'
Hi,
What is the length of your number?
You can try with
num(Field, '#,###,###.00') as Field
Regards
ASHFAQ
Hi,
works out-of-the-box:
however check your decimal seperator in the script:
with my default value (comma), it works like this:
hope this helps
regards
Marco
Hi,
Try like this
=Num( '3.4115809049999998E+03')
OR
=Num(FieldName)
OR
=Num(FieldName, '#,###.00') - Formatting the converted number
Regards,
Jagan.