FRED_SHEET
New Member
- Joined
- Oct 13, 2017
- Messages
- 37
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.