Excel VBA Tips: Convert Number to Text

By

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

Advertisements