How to convert text to number?
Add a 0 (zero) to any blank cell. Copy the zero. Select the text. Right
click. Paste Special - Add. The text will be converted to numbers...
--
HTH...
Jim Thomlinson
"frenchtoast" wrote:
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!
|