Change a 2-3 digit number/string to a 5 digit number/string

[kp88]

I have a workflow where I need to convert a 2 or 3 digit string (or number) to a 5 digit string (or number). Ex: change 102 to be 00102. In Excel, I would use the formula text(ref cell,"00000") but can't find anything similar in formulas or by trying to convert to a string. 

[ddiesel]

Try this formula:

PadLeft(tostring([Field1]),5,"0")

I found the answer in this post by @patrick_digan

How do I pad leading Zeros?

See attached.

[kp88]

Hmm I'm still having issues. I already have the field type as a String. With the "" around the 0, I'm now getting the below error

The field "" is not contained in the record. (Expression #1)

formula is padleft([RecID],5,"0")

Any thoughts?

[ddiesel · Accepted solution]

Try giving a name to your Output Column in your Formula tool.

Where it says "Select Column", drop down to choose a column to replace or click "+ Add Column" and type a description.

[kp88]

Oh DUHHH! Thank you!