Text-to-Number Conversion Method Actin-a-Fool

[jrnewport1115]

So I'm familiar with with many methods for converting text to numbers on a vlookup error. I normally use either the past multiply (by 1) or the paste add (by zero).

However, this didnt work this time around. I had to use ALT+AEF (the delimiter route - and it worked).

Fine and dandy but I really want to know why this method worked and the first didn't. Anyone have any ideas???

 

[Scott Huish]

Hard to say without a formula or anything to go on.

But, what do you mean by converting text to a number on a vlookup error? If VLOOKUP errors, you get a #N/A error. How are you converting this to a number?