Show denominator and numerator of fraction

[Cosmos75]

If I have a cell to be formatted as a fraction, is there anyway to get the denominator and numerator of the fraction.

E.g.

If Excel has .26163 as 45/172 in Cell A1, is there anyway to get a cell B1 to show 45 and Cell C1 to show 172?

FYI, 3.26163 lightyears is 1 Parsec.

 

[santah]

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

Please help. Thanks,

 

[XLXRider]

Brilliant. Works for me. Thanks!

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

 

[KSANG]

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..