How do I convert an integer variable to a string variable?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am trying to build a formula in string format for pasting, but want to add a number to it. But when you try to append an integer variable to the string it comes up with a type mismatch error. How can I convert the integer variable to a string? The value function from Excel does not seem to work

Thanks
 
The Str function converts a number to a string. For instance:

Str(123)

This is if you are writing a macro with vba. If you are writing a formula in
a cell then I can't help you.

Rui

dumbass said:
Hi-

I am trying to build a formula in string format for pasting, but want to
Click to expand...
add a number to it. But when you try to append an integer variable to the
string it comes up with a type mismatch error. How can I convert the integer
variable to a string? The value function from Excel does not seem to work.
 
This should work

myVal = 123
myString = "abc" & myVal

or to be sure

myString = "abc" & CStr(myVal)
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

dumbass said:
Hi-

I am trying to build a formula in string format for pasting, but want to
Click to expand...
add a number to it. But when you try to append an integer variable to the
string it comes up with a type mismatch error. How can I convert the integer
variable to a string? The value function from Excel does not seem to work.
 
Back
Top