Convert scientific value into text

[Dittau]

Hello,i need help converting a column that could have scientific value sinto a 9 character string

example inputs:

4.6655E+104

3.795E+263

expected output:

46655E100

37950E259

Please let me know how i can convert this

[JosephSerpis · Accepted solution]

Hi @Dittau this article may be useful for you https://knowledge.alteryx.com/index/s/article/Converting-Values-from-Scientific-E-Notation-158346017...