=VALUE(A2)
or use Data/ Text to Columns.
--
David Biddulph

"frenchtoast" wrote in message
...
I have rows of data.

ie. '12345
and I want to use vlookup using number value 12345.

There isn't an error message (with pull-down arrow) to convert this '12345
into a number.

How do I convert this without having to manually change these cells?

Thanks!