Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert number to text ( Text Function in Excel )

fikrizahari
8 - Asteroid

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

AmountAmount in Text
1181.37000001181.37
813.56000000813.56
121.7000000121.70
29.7000000029.70
25001.93000025001.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 !

3 REPLIES 3
ShankerV
17 - Castor

Hi @fikrizahari 

 

One way of doing this.

 

ShankerV_0-1682587230388.png

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

 

ShankerV_0-1682587427469.png

 

 

Many thanks

Shanker V

binuacs
21 - Polaris

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

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

binuacs_0-1682587267603.png

 

fikrizahari
8 - Asteroid

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.

Labels
Top Solution Authors