Need help converting number string to number
 

I am trying to figure out how to convert a number string, like "11291", to a
number 11291. I am trying to use it in the following If statement:

If Right(SAPws.Name, 5) = SAPws.Range("B2").Value Then

Right(SAPws.Name, 5) evaluates as a string: "11291", and
SAPws.Range("B2").Value evaluates as a number: 11291

I need to get the if statement to evaluate to TRUE. Please help.

Need help converting number string to number
 

If cDbl(Right(SAPws.Name, 5)) = SAPws.Range("B2").Value Then
--
Jim Cone
Portland, Oregon USA



"Ayo"

wrote in message

I am trying to figure out how to convert a number string, like "11291", to a
number 11291. I am trying to use it in the following If statement:

If Right(SAPws.Name, 5) = SAPws.Range("B2").Value Then

Right(SAPws.Name, 5) evaluates as a string: "11291", and
SAPws.Range("B2").Value evaluates as a number: 11291
I need to get the if statement to evaluate to TRUE. Please help.

Need help converting number string to number
 

Wrapping both sides of the equation in Cstr() (convert number to string)
should do the trick.

if Cstr(Right(SAPws.Name, 5)) = cstr(SAPws.Range("B2").Value) then
--
Steve

"Ayo" wrote in message
...
I am trying to figure out how to convert a number string, like "11291", to
a
number 11291. I am trying to use it in the following If statement:

If Right(SAPws.Name, 5) = SAPws.Range("B2").Value Then

Right(SAPws.Name, 5) evaluates as a string: "11291", and
SAPws.Range("B2").Value evaluates as a number: 11291

I need to get the if statement to evaluate to TRUE. Please help.

Need help converting number string to number
 

Thanks.

"AltaEgo" wrote:

Wrapping both sides of the equation in Cstr() (convert number to string)
should do the trick.

if Cstr(Right(SAPws.Name, 5)) = cstr(SAPws.Range("B2").Value) then
--
Steve

"Ayo" wrote in message
...
I am trying to figure out how to convert a number string, like "11291", to
a
number 11291. I am trying to use it in the following If statement:

If Right(SAPws.Name, 5) = SAPws.Range("B2").Value Then

Right(SAPws.Name, 5) evaluates as a string: "11291", and
SAPws.Range("B2").Value evaluates as a number: 11291

I need to get the if statement to evaluate to TRUE. Please help.