Excel vba - convert string to number

string vba numbers vlookup

use the val() function

string vba numbers vlookup

If, for example, x = 5 and is stored as string, you can also just:

x = x + 0

and the new x would be stored as a numeric value.