Help with Trim formula

[rockeylearning]

Hi Everyone,

Can someone help me on how I can use Trim to trim numbers like below?

Example: 120000123, 1200065698, 1203697 etc..I want only to keep everything after the 0.

so the result should be 123, 65698, 3697.

The length is not always the same, there can be one zero, there can be two or many zeros, and the 120 always in front.

Thank you for your help

~Newbie

[binu_acs]

@rockeylearning Try the below formula

[alexnajm]

Here you go!

[rockeylearning]

@binu_acs thank you! This works

[rockeylearning]

@alexnajm , thank you! your solution also works