remove leading zeros in a text string? 2

[legos]

say i have a string of text with several leading zeros.
exp.
000012345

i want to convert this to an integer using the Cint command. But it will not work unless i remove the zeros. Basically i'd like to use something like the Ltrim function, but with it removing zeros instead of spaces.

Durible Outer Casing to Prevent Fall-Apart

 

[CajunCenturion]

You might try

OldStr = "0000012345"
NewStr = Trim(Val(OldStr))

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[legos]

that works perfectly!!! thanks alot

Durible Outer Casing to Prevent Fall-Apart