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

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.

Preparation

Accepted answers

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.

All comments

Try this formula:

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

How do I pad leading Zeros?

See attached.

Change a 2-3 digit number string to a 5 digit number.yxmd

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?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703