Convert number to text ( Text Function in Excel )

[fikrizahari]

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 !

[ShankerV · Accepted solution]

Hi @fikrizahari 

One way of doing this.

padleft(ToString([Amount],2),12,"0")

Many thanks

Shanker V

[binuacs · Accepted solution]

@fikrizahari One way of doing this with the PadLeft() function

PadLeft(toString([Amount],2), 12, '0')

[fikrizahari]

Hi @ShankerV and @binuacs ,

Thank you so much for quick response.
It worked like a charm !

I will close this question and mark as solution.