I'm trying to do a vlookup on two spreadsheets, the reference number is
formated as a number, the data source is formated as text. How can I change
one of the number to either text or value to match the other one? I know it
can be done with do a text to column funtion but I was hoping to be able to
do it inside the formula.