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.