FIND when leading zeros have been added to a number, or not! ...

[adambc]

I have a routine that uses values from 2 input boxes to retrieve an ID from one WB ...

I then use the ID to loop through many (50+) other WB and using FIND if the ID exists in a WB writes the WB.Name to a list ...

But ... some of the WBs I'm looping through have the ID but with leading zeros (I can't control this or edit the WBs) added eg

ID = 52 could be 052 or 0052 or 00052 etc in the WBs I'm looking for matches in ...

Any ideas how I can cope with this?

 

[dreid1011]

It sounds like the IDs are stored as text for some of the workbooks. Can the IDs contain letters as well as numbers? If not, and the IDs are all numeric, you can force the IDs to numeric and it will remove the leading zeros.