i have a spreadsheet that is 10K lines long. the first column basically
contains numbers (7 digits) but some of the rows are actually alphanumeric.
i then did a vlookup to look up some data from another workbook. they all
came back invalid. However, if I go into a cell, put the cursor at the end
of the number, and then hit enter....the number becomes right justified and
the vlookup value is shown.

not sure what is wrong with the number format, but what can i do short of
going into each cell and hitting enter in order to get the vlookup to work
properly?

thanks in advance for the help!