I download data from JD Edwards into excel and do a vlookup with another
excel spreadsheet. Although I change the format of the column (I am doing a
vlookup) to match the column of the other spreadsheet (format-cell-text, or
whatever) it still does not match. I also tried Data-Text to
column-next-next-finish which sometime works. Although they are both set to
TEXT, it cant find it.

Is there a better way to match the format of columns I am comparing to text
(or number) or whatever, as long as they become perfectly the same.
Thanks.