How to Convert Text To Number in Excel

[nagaraja.sadar]

Hi All,

1. I have cell A! filled with 5:1 and the cell ix "TEXT" formatted.
2. I want to extract 5 out of it (I did the same using the formula =LEFT(A1,FIND(":",A1,1)-1) ).
3. Now i want to check a condition whether 5 (extracted value) is < 6 (Here 6 is constant not in any cell).
4. I tried with =IF((LEFT(C12,FIND(":",C12,1)-1)<"5"),"YES","NO") but it is always printing NO as result even though if i change the value in cell A1 to 5 or 7.

Any help appreciated. Further i need to extract second part and check that value for some condition.

Regards,
Nagaraja S

[zbor]

use this:

Please Login or Register  to view this content.

Also, it would be better to use:

Please Login or Register  to view this content.

to avoid error

[Pete_UK]

You are comparing text strings. Do it this way:

=IF(--LEFT(C12,FIND(":",C12,1)-1)<6),"YES","NO")

To extract the second number (as a number) you can use:

=--RIGHT(C12,LEN(C12)-FIND(":",C12,1))

The double-minus converts the text value to a number, but you can also add zero or multiply by 1 to get the same effect (-- is the same as multiplying by -1 twice, but is quicker to type).

Hope this helps.

Pete