Need help converting number string to number

[Ayo]

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.

 

[Jim Cone]

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



"Ayo"
<[email protected]>
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.

 

[AltaEgo]

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

 

[Ayo]

Thanks.

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