Add as many 0s in front to get 8 characters

[SylviaK]

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

[atcodedog05 · Accepted solution]

Hi @SylviaK 

Formula would be 

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

Workflow:

Hope this helps : )

[SylviaK]

Many thanks. That works

[atcodedog05]

Happy to help : ) @SylviaK