Macro Variable Code

Is there a macro variable code that will allow the variable to look at Text and read it like a number?
I have numbers that are placed in my spread sheet as Text, and I need to get an Average of a small group of them. I have tried converting them to numbers, but that causes errors for other macros.

Dim MyVarName As ?