I am doing the scanning of an identity document, but when it does it adds two zeros to the beginning of the document in column (Nยฐ Cรฉdula),
I am trying to remove those two zeros with the SUBSTITUTE formula but it also removes the two zeros that are after the โ8โ, I tried with the formula LEFT tell it to only remove the first two zeros from the beginning but it doesnโt work, do you know how I can improve the formula?
Try using just this as your expression:
NUMBER([Nยฐ Cรฉdula])
I already tried but it does not remove the two zeros that are at the beginning
Expression Steve showed should work.
I suspect you set the field data type with this expresssion (VC) to text instead of number type.
User | Count |
---|---|
41 | |
35 | |
27 | |
23 | |
16 |