You can use expression builder to do same
CINT(TEXT value) will convert into numeric
I think you actually want CDbl(Text Value) if your dealing with non-integer values.
You can use VAL(Text value) to extract numeric value from string.
Last Wiki Answer Submitted: May 8, 2013 3:53 pm by Michael Tidmarsh11,400 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
Cint(text1.text) – will covert the string(value) to an integer value.
val(text1.text)- will get the value from the textbox 1 and returns a value
Cdbl(text1.text) – will covert whatever is inside textbox 1 to and returns a value that supports decimal places in it.