How to convert text to number?
It isn't very obvious how your message relates to the earlier part of the
thread, but try:
=SUBSTITUTE(A1,",OK,0","")
--
David Biddulph
"Zuj" wrote in message
...
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!
|