Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

[OmarBenSalem]

Hi guys ( stalwar1 )

I have a field like this:

I was wondering, how can I format it as a number? withou the E thing?

Thanks

[sunny_talwar]

Something like this

=Num(2.3782E-5, '0.000000')

=Num(FieldName, '0.000000')

[OmarBenSalem]

When I do this, here's what happens:

[sunny_talwar]

Might need to add more 0s (=Num(2.3782E-5, '0.000000000'))... not sure but I see this, when I use this in text box object

[OmarBenSalem]

even with a lot of 0.0000000000000000 that does not seem to work

[surendraj · Accepted solution]

May be this!!

=Num('2.3782E-5', '(dec)')

[OmarBenSalem]

That's the first time I see this !

Great Surendra !!

[sunny_talwar]

Me too ... Well I have seen this before, but never used it to know how it works

[surendraj]

Glad to help!!

Please go through

Conversion of Exponential Notation to Decimal numbers

@omarbensalem