I haven't looked at the other postings wherever they are
but having an incorrect answer in thread would certainly
confuse someone, so...

What you have is an ID you should not think of them
as numbers, since you will not be treating them
numerically. They might even have leading zeros
unless specifically designated otherwise.

In any case Excel can only have 15 digits
for a number -- and it was stated the
Vehicle Title Numbers are seventeen digits

Most credit cards have 16 digits, and that also is beyond
Excel specification -- you must treat it as text.
Look up specifications in HELP (F1).

Format the column as Text to be the safest. You could
type a single quote in front of the VIN but a macro won't
pick that up so you could end up with the same mess
later on.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DNA" wrote in message lkaboutsoftware.com...
Format the cells as "Number". It appears it's formatted as "General".