Add as many 0s in front to get 8 characters

hi,

I would like to get from old below to new. Not sure how this can be done?

Old	New
23	00000023
12345	00012345
235	00000235
77788899	77788899
65440	00065440

Many thanks,

Sylvia

Preparation

Accepted answers

Formula would be

PadLeft(ToString([Old]), 8, "0")

Workflow:

Hope this helps : )

All comments

Formula would be

PadLeft(ToString([Old]), 8, "0")

Workflow:

Hope this helps : )

Many thanks. That works

Happy to help : ) @SylviaK

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703