Vlookup problem when number is formatted as "special"
Posted by KELLY J on February 14, 2002 8:40 AM
i think i need to try to be a little more clear with my question. i am trying to do a vlookup and the column that it is using is formatted as "special", the vlookup will not recognize the number in that column until i change the format on that column to "text" and then retype the number by hand. why is it doing this and how do i fix it without having to retype an entire column of numbers ?