LinkBack URL
About LinkBacks
"B2" '3/16X12
"C2" =LEFT(B2,FIND("X",B2)-1)
returns 3/16
How can I convert it to fraction?
"B2" '3/16X12
"C2" =LEFT(B2,FIND("X",B2)-1)
returns 3/16
How can I convert it to fraction?
In cell C2, try this:
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
It does not work. Still extracted as a date.
Try
=LEFT(B2,FIND("/",B2)-1)/MID(B2,FIND("/",B2)+1,FIND("X",B2)-FIND("/",B2)-1)
Format as # ?/??
Life's a spreadsheet, Excel!
Say thanks, Click *
=VALUE("0 "&C2)
or, if you want it in C2
=VALUE("0 "&LEFT(B2,FIND("X",B2)-1))
than you. much appreciated. as i thought it would me long method.
"B2" '1-3/16X12
"C2" =LEFT(B2,FIND("X",B2)-1)
returns 1-3/16
but reads as a date
How can I convert to "C2" to fraction?
Thanks.
version 1: This not not work on the above problem
"B2" '3/16X12
"C2" =LEFT(B2,FIND("X",B2)-1)
Solution:
=VALUE("0 " &C2)
Hi -
I copied and pasted your example into a blank spreadsheet and it appeared to work o.k. Are you having a formatting issue? When you say it reads as a date, do you mean January 3, 1916?
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
it should treat it as a 1.1875 in fraction format, not as a date March 16, 2001(as it appears mine)
well you can using an old excel4 macro but you need it to be used in a named formula
where exactly is this data you want to convert? it matters because of the construction of the named formula
but lets assume its col b define a name as say"mysum"
=EVALUATE(SUBSTITUTE(Sheet1!$b1,"X","*"))
then with 1-3/16X12 in b2
=mysum in c2 will give
-1.25
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks anyway, I just got an idea on your post.
=VALUE(SUBSTITUTE(LEFT(B2,FIND("X",B2)-1),"-"," "))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks