Thanks:  0
Likes:  0

# Thread: Show denominator and numerator of fraction

1. ## Re: Show denominator and numerator of fraction

Hello,

I have a value like 18 25/374, an I am getting the numerator vale correctly as 6757, but get a #value! for the denominator.
Using the formula posted as:
=LEFT(TEXT(A1,"???/???"),FIND("/",TEXT(A1,"???/???"))-1)+0 ==> FOR Numerator
=RIGHT(TEXT(A1,"???/???"),FIND("/",TEXT(A1,"???/???"))-1)+0 ==> For denominator

2. ## Re: Show denominator and numerator of fraction

Brilliant. Works for me. Thanks!

Originally Posted by IML
There may be a better way, but
num
=LEFT(TEXT(A1,"???/???"),FIND("/",TEXT(A1,"???/???"))-1)+0

denom
=RIGHT(TEXT(A1,"???/???"),FIND("/",TEXT(A1,"???/???"))-1)+0

3. ## Re: Show denominator and numerator of fraction

Hello.... this is how it worked for me when the formula included the equal "=" sign...

=RIGHT(LEFT(FORMULATEXT(A1),FIND("/",FORMULATEXT(A1),1)-1),LEN(FORMULATEXT(A1))-LEN(LEFT(FORMULATEXT(A1),FIND("/",FORMULATEXT(A1),1)-1))+1)
=RIGHT(FORMULATEXT(A1),LEN(FORMULATEXT(A1))-FIND("/",FORMULATEXT(A1),1))

Took me a while to make this work... The thread above does not work for me... could be caused by the difference in Excel version? Anyway, thanks everyone for the tips..

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•