Need a total of 6 characters in each row by adding zeros

[mcas1]

I have:

10A2O1

10A

10A2

What i need:

10A201

10A000

10A200

Essentially, i need to make sure that there are always 6 characters total in the column, and anywhere that it doesn't add up to six, add a 0 to make it six.

Thank you!

[atcodedog05 · Accepted solution]

Hi @mcas1 

Here is a workflow for the task.

Formula

PadRight([Field1], 6, "0")

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[joshuaburkhow]

Hey @mcas1 

This is as simple as just using the padright([FieldName],6,"0") function in a formula tool!