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!



Posted by:submeg

Musician, Writer and Inspirer. I discuss the projects I am working on, the services I provide and my general thoughts.

One thought on “Excel VBA Tips: Convert Number to Text

  1. 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.


Tell me what you think!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s