Text to Number

Hafeez Esmail · Oct 10, 2003

Is there an automated way in which I can convert a text
data type to a number data type?

Please Help

Hafeez Esmail

Cheryl Fischer · Oct 10, 2003

Check out the Val() function.

Clinton · Oct 10, 2003

Try
CInt(stringVar) [Convert to Integer function]
CLng(stringVar) [Convert to Long Integer function]