I have two lookups that are referencing two workbooks. The problem I have is the numbers in my workbooks are different. They are in regular text. The numbers in the other workbook all have a ' sign in front of them. For example my workbook has 1004. The other workbook has '1004. I cannot change the numbers in either workbook. Is there a way I can create a lookup that inserts the ' if the number is numerical? Not all the numbers have the problem. The ones that start with text, like

AR132509BB1 are fine. |

<tbody>

</tbody>

Any thoughts?

Thanks,

Rodney