Converting numbers to text

[Guest]

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

 

[Bob Phillips]

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)