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.
Just add +0 to the formula
=LEFT(B2,FIND("/",B2)-1)+0
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks Alkey, it wont let me add more reputation right now to you, says I have to spread it around lol, thanks though really appreciate it.Originally Posted by AlKey
Thanks Alkey, it wont let me add more reputation right now to you, says I have to spread it around lol, thanks though really appreciate it.
LEFT/RIGHT/MID always return a text answer, even if it looks like a number.
Convert with any of these...
=--LEFT()
=LEFT()*1
=LEFT()+0
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks