Scientific Notation error

Amy123

Hi Team,

Can someone help how to convert the Scientific Notation to Number along with String value in one column.

Invoice	Correct Invoice
1.19E+35	119191111111111000000000000000000000
20202020202	20202020202
Commercial 123	Commercial 123

Invoice column is flowing from the Input data i want correct invoice column with a formula that convert the scientific notation to number 

Thanks

DawnDuong

hi @Amy123 

Alteryx can read the scientific notation as numeric value. If you want to change how the number is displayed, you can use ToString to format, as per the example attached here.

String format.yxmd