How do I remove leading zeros

[Khristian_Evans]

Need Help removing leading zeroes , I want record to be just 1 not 001 

[alexnajm]

ReplaceChar([RecordID], "0", "")

[Khristian_Evans]

Thanks for the quick reply, unfortunately I don't think that formula will work, That will replace ALL zeroes so "20'' would return '2' , do you know a formula for just leading zeroes? 

[alexnajm]

Great shout - in that case I'd just convert to a number 😊

[alexnajm]

You can also use TrimLeft: How To: Remove Leading Zeros From a Field

[flying008 · Accepted solution]

Hi, @Khristian_Evans 

Maybe you can use formula with :

ToString(ToNumber([RecordID]))

or

TrimLeft([RecordID], '0')