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!
Submeg
IT
SUBMEG 
We are a gaggle of volunteers and opening a brand new scheme in our community.
Your site provided us with valuable info to work on. You have done a
formidable activity and our whole group shall be grateful to you.
LikeLike