Enter symbols (text, numbers) into the field

[AlexWest]

Hi!

I pictured my question (attached).

Well I have a field which has to contain a 12-digit numeric record.

But some of the records are 11-digit .

As you can see on the picture there is "0"-symbol is absent. But I need to add it to the records which 11-digit.

Is it possible? If yes, how can I do this?

[Afa_Momin · Accepted solution]

Try the following code:

if(len([Field_Name])=11,0&[Field_Name],[Field_Name])

[AlexWest]

Hi!

Sorry for late answer,

It's working well. Thanks a lot for your help!))

[Vegar]

An alternative solution is to format the  field as an 12 digit number. You can try this:

NUM(Field_Name, '000000000000')

If you have trouble interpreting the field as a number then also this could work:

right('0'&Field_Name, 12)