Need help converting number string to number

  • Thread starter Thread starter Ayo
  • Start date Start date
A

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

AltaEgo said:
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
Click to expand...
 
Back
Top