remove initial zeros

[rupaliqlik]

Hi Folks,

Want to remove initial 2 zeros from below field.

0040111100

expected output.

40111100

@abhijitnalekar 

Thanks,

Rupali Ethape

[ManuelRühl · Accepted solution]

try

=right(FIELD,len(FIELD)-2) as FIELD_NEW

[AshutoshBhumkar]

Hello,

You can try Num#(Dimension)+0

[Anil_Babu_Samineni]

You can use

=Trim(Num('0040111100'))