Text to Number

H

Hafeez Esmail

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

Please Help

Hafeez Esmail
 
C

Clinton

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Custom Number sequences 0
Internal Data Integrity (Type 4) Details Needed 1
Tracking Resources as Trade Types - Rather than Individuals 1
Select Text to End of Footnote 9
Finding the proper style field and the numbered paragraph value within the style 0
Creating a Search using a combo box and then creating a report. 4
MS Word normal.dot cannot be fixed 'text box' appears each time 4

Top