Dear All

can you tell me how can i covert (1/1,OK,0) into (1/1). i want the (OK,0) to
be removed completely from the field.



"frenchtoast" wrote:

Hi Chris.

I tried this as well, though it returned #N/As.

"Chris Lavender" wrote:

Hi frenchtoast

Assuming your 12345 is in cell A21, the TEXT function will convert it to
text format, which will then match the format type in your data

=VLOOKUP(TEXT(A21,"0"),C:D,2,0)

HTH
Best rgds
Chris Lav

"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!