Excel VBA Tips: Convert Number to Text
I have covered how to do this using worksheet formulae, but it can also be done using vba.
If your variable (that is a number) is called Number, to convert this to text, use the following code:
Number = CStr(Number)
It will now be stored in text format.
Come check out the directory for the rest of my excel tips!