This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
While reading data from Excel source many times in case of very large/very small numbers it get's converted into exponential format. Currently we do not have anything in Alteryx to handle exponential numbers and convert them into numbers. "Exponential Notation. Exponential notation lets you move the decimal point in a number. It simplifies numbers by getting rid of zeros, and making math easier. Getting rid of zeros helps with big 100,000,000 and small 0.000,000,001 numbers. The Scientific format displays a number in exponential notation, replacing part of the number with E+n, where E (which stands for Exponent) multiplies the preceding number by 10 to the nth power. For example, a 2-decimal Scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power."