REMOVE LEADING ZERO IN THE DIGITS

[dunkindonut7777]

Hi I would like to know the exact formula of removing the zero at the start of the digit.

Here I have:

Code:           Expected Output:

001               01

002               02

003               03

011               11

012               12

Can you help me with this one pls?

[atcodedog05 · Accepted solution]

Hi @dunkindonut7777 

I would say use Right([Field], 2) Or REGEX_Replace([Field], "^00","0")

Hope this helps : )