SUBSTITUTE values

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?

0 3 96
3 REPLIES 3

Steve
Platinum 4
Platinum 4

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.

Top Labels in this Space