Trim zeros from front of string ?

[mscertified]

Is there an easy way to trim zeros from the front of a string? The Trim
function will only trim spaces.

 

[George Nicholson]

Val() returns as much of the numerical value from the beginning of a string
as it can (not including any leading zeros).

Val("00123460")
and
Val("1234 60th Avenue")

both return 123460 (as a number).

HTH

 

[DrGUI]

try cstr(cint("0003450"))

 

[John W. Vinson]

try cstr(cint("0003450"))

or - safer because it will handle numbers over 65535 and also faster -
cstr(clng("00871243"))

John W. Vinson [MVP]