Hi,

I am having a difficulty that has been bugging me for some time.

I have 14 digits SCC codes. Some start with 1-9, some start with 0's.
Numbers stating with 0's have to be set up as text or the 0 disappears.
Whenever I set up a number as text and I do a vlookup, those numbers
are not being recognized as matching by the vlookup function. My
question is: "how can I have a 14 digit number displaying zeros in
front and still be able to compare it to another spreadsheet with the
same number using the vlookup function. Please help.



Mike