result of Function to cut last 2 values out

[ifew552]

i have used =--LEFT(L3, LEN(L3)-2). This cut off last 2 digits o
value. i.e. 12345678912 became 123456789. But 00123456789 becam
1234567. How do I make it come out 001234567??? thanks

 

[Arvi Laanemets]

Hi

=INT(L3)
or
=INT(L3*1)
when in L3 is numeric string

 

[Aladin Akyurek]

Drop the -- bit if you want all output as text.