How to convert s pure digit Sting to a Integer

like convert "55" to Integer 55

[email protected]

use Int, i.e Int("55")

dim strS as string
dim intNumber as integer, lngNumber as long, dblNumber as double

strS = "55"
intNumber = Cint(strS)
lngNumber =Clng(strS)
dblNumber =Cdbl(strS)

Have fun.


Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood Bruno Paris and all the other wonderful people who made and make Codeguru a great place. Come back soon, you Gurus.

... to tell the truth, my example was a little short:

dim strS as string
dim intNumber as integer, lngNumber as long, dblNumber as double

strS = "55"
if isnumeric(strS) then
intNumber = Cint(strS)
lngNumber =Clng(strS)
dblNumber =Cdbl(strS)
end if


Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood Bruno Paris and all the other wonderful people who made and make Codeguru a great place. Come back soon, you Gurus.