Is it leading zeroes? If so, just format the cell as 00000000

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jeanette" wrote in message
...
I have a vlookup formula setup as follows:
=VLOOKUP(A7,'[sp 500 constituents.xls]Classification'!A$2:J$501,5,0)
The value listed in column 5 on "the sp 500 constituents" spreadsheet has
a
8 digit number. This value is only showing the first 4 digits in the
second
spreadsheet, where I need data. I have checked the format, so that they
both
show as numbers. What could be the problem as to why the result only
shows
the first 4 digits? Help!