converting the values from Scientific E-notation

[aajvory]

Hello Community,

I need your help with converting the values like:
8.02188E+15
1.802E+12
9.85622E+14
9.85622E+16

The best option seemed to me to use the TONUMBER() function in a formula tool and it converted numbers like this:
8.02188e+15
1802000000000
985622000000000
9.85622e+16

As you can see the numbers which contained +15 and +16 didn´t convert. I think that I've tried almost everything, but I don't know how to proceed. Can someone help me with this, please?

Thanks in advance.

[DataNath · Accepted solution]

Hey @aajvory, there's a good article on this here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Converting-Values-from-Scientific-E...

In your case, you could change the data type to a fixed length that will accommodate up to the largest of these:

[binuacs · Accepted solution]

@aajvory One way of doing this

[aajvory]

Hello guys,

thank you for your reply, both solutions worked. I found out that a problem was with the data source.

[Ous1995]

How can i compute the size that should be put for fixed decimal ?