VB Code
Rick, Thank you for your help.
You are welcome. I am assuming the formula does what you want and covers the
years you are interested in (I couldn't find very much about the structure
of VIN numbers prior to 1981).
The industry will no doubt revert to the
Letter system that was in use before 2000.
As I said, what a mess that system is... hell, they didn't even start with
the letter "A" back when they first started using letters (so, assuming you
are right about the letters, who knows what letter they would use for 2010
then).<g
Rick
|