Removing leading zeroes from the values

[Ns7703]

I want to remove leading zeroes from the values , like if I am having value 00760027220 from this value I want to remove zeroes coming in the starting '00'760027220 . How to remove it?

[mpc · Accepted solution]

Hi, 

Try this: Num(Num#(MyField, '#0')), my bad

Regards

[Shai_E · Accepted solution]

Hi @Ns7703 

If this is via QAA, and the value is a string you can use the "left trim" formula on it to remove the character 0