Converting Find formula from Text to Number

Hi when using the find forumla, it turns my numbers into text

e.g
data
12/11

=LEFT(B2,FIND("/",B2)-1)

Result
12

The 12 is now text not a number.

I can use the =(Value) formula in a new cell to convert the text back into a number, but it looks ugly.

Is there a way to use the find formula and value formula together, so I can pull the numbers out and view them again as numbers not text.

It's the LEFT function which is returning the characters as text, as that is what is does. You can add zero, or multiply by 1, or use the double unary minus (--) to convert the result to a number, like this:

=LEFT(B2,FIND("/",B2)-1)+0

=LEFT(B2,FIND("/",B2)-1)*1

=--LEFT(B2,FIND("/",B2)-1)

Hope this helps.

Pete