I'm trying to do a vlookup involving some numbers.
The numbers I'm using to lookup, are behaving like text. And so the Vlookup doesn't work.
If I overtype the numbers they behave like numbers. But there are too many to type.
e.g. in cell A1 the number is 1234. A vlookup involving this no. wont work.
If I overtype in cell A1, with 1234. The vlookup works.
Help.
The numbers I'm using to lookup, are behaving like text. And so the Vlookup doesn't work.
If I overtype the numbers they behave like numbers. But there are too many to type.
e.g. in cell A1 the number is 1234. A vlookup involving this no. wont work.
If I overtype in cell A1, with 1234. The vlookup works.
Help.