Hi,
Greetings !
I would like to know if there any formula to convert number to text as per below :
Amount : Example number
Amount in Text : Desired output
Amount | Amount in Text |
1181.37 | 000001181.37 |
813.56 | 000000813.56 |
121.7 | 000000121.70 |
29.7 | 000000029.70 |
25001.93 | 000025001.93 |
Currently in excel, i used this formula :
=TEXT([Amount],"000000000.00")
But i was not sure in Alteryx.
The output should be contained of 12 characters including 2 decimal places, doesn't matter the amount.
Thank you in advance !
Solved! Go to Solution.
@fikrizahari One way of doing this with the PadLeft() function
PadLeft(toString([Amount],2), 12, '0')