How do I pad leading Zeros?

[brad_shannon]

I have:

1234500

I want:

00001234500

I'm new.

[manishab]

Hi Patrick, 

I have the value in this format:

0220694, 0095624

I want to convert this to a currency format 220,694.00, 95,624.00. 

Any help would be greatly appreciated. 

Thank you 

Manisha 

[brad_shannon]

You may need to divided by 100 first.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Everything-You-Need-to-Know-About-C...

[Sammie]

Hi thanks, 

i tried to replicate the formulate to V_String but didnt work using: 

PadLeft([Field1],4,"0")

The data contains example below:

300

1229

2120

Only the first one will need to add zero to it at the beginning '0300'.

Can you please assist? 

thanks!

[ATB2022]

Sorry, complete beginner, where do I need to be to see the Option to 'Padleft', thanks