|You have pointed out that the month might be 1 or 2 digits, which is fairly easy to deal with, if that's the only issue.|
However, you didn't say anything about the day. Will they also be 1 or 2 digits? If so, then we have a problem.
If both the month and day can be one or 2 digits, there no way for anyone to know what 1112012 means.
Is that 11/1/2012 or 1/11/2012?
If that's the case, then I think you need to deal with the source data, unless you have some other way of knowing what to do with dates like 1212012, 1142012, etc.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.