converting the values from Scientific E-notation

Question

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 Answer

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

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

binu_acs · Accepted Answer

@aajvory One way of doing this