Here's a handy formula that will trim leading zeros (any number) in data that might contain mix of numbers and text.
MID([Field 1], SEARCHREGEX(`[^0]`, [Field 1]), LEN([Field 1]))
Paola Tomei
Here's a handy formula that will trim leading zeros (any number) in data that might contain mix of numbers and text.
MID([Field 1], SEARCHREGEX(`[^0]`, [Field 1]), LEN([Field 1]))