Try using a double unary (--) in the formula

=VLOOKUP(--A1,M1:N20,2,False)



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"bobs" wrote in message
...
Is there a more efficient way to convert a number to a text value other
than
using the =trim(number) formula? I use vlookup often...and it doesn't
recognize a text entry of say "6001" with the number 6001 unless I convet
the
number to a text value with the formula =trim(6001) and then converting
the
formula to a value. Please advise as to whether there is a better way.
Thanks, Bob