How I can remove leading zeroes

[sparur]

Hello, colleagues.I have a small problem, which I can't resolve elegant.

I want to remove leading zeroes from my Data.

I tried to do some text / num converting, but it didn't help me.

See attached file

[nsetty]

'0000010 * 1'  = 10

[swapnilpatil21]

In my case I had both numeric and alphanumeric values in the same field.

Below worked for me..

if(Isnum(num(Num#(PROFIT_CTR))),text(num(Num#(PROFIT_CTR))),PROFIT_CTR)

Swapnil