Transformation of values' lenght in a field based on the number of caracters

[Tatynout]

Hello,

I would like to add a new field by applying a condition on data values from my Vendor field. I want to set each values in that field so they all have 10 characters and to do so i want to apply a condition in such a way that if the value's lenght is smaller than 10 then 0 should be added in front of the value until it makes 10 characters.

For Example:

Vendor

0045676

000034567

76890650

2340987653

I should get the following results:

Vendor

0000045676

0000034567

0076890650

2340987653

Thanks for your help.

Regards,

Tatiana

[#2 · Accepted solution]

@Tatynout 

You may apply custom format with 10 zeroes

[#3]

@Sergei Baklan Thank you!

[#4]

@Tatynout , you are welcome