Separating Numerator and Denominator of a Fraction formatted Cell into two Separate Cells

[FRED_SHEET]

I have a cell (A1) with a decimal value of 0.34375 in an adjacent cell (B1) which is equal to (A1) but is formatted as a fraction function with two digits to give a fraction of 11/32. Is there any way I can convert the fraction into two different cells (C1) and (D1) one for the numerator (C1) and the other for the denominator (D1)? In other words I want C1 to display 11 and D1 to display 32.

 

[Rick Rothstein]

Give this a try...

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

and...

=0+MID(A1,FIND("/",A1)+1,9)

 

[Miles91]

its single digit after the decimal, but single or double before.

 

[Miles91]

i'll try it out, thanks!