I use a custom format (#??/16) to convert the integer contents of two cells to a fraction so that A1=16, B1= 16 , then target cell (C1) displays 16/16 (or a fraction thereof in sixteenths without the least common denominator kicking in) i.e., not 1.
I need to convert that exact fraction displayed in C1 to text in D1 order to concatenate it with a string in E1 and display the concatenated string in F1.
Ideas?
Audiology
I need to convert that exact fraction displayed in C1 to text in D1 order to concatenate it with a string in E1 and display the concatenated string in F1.
Ideas?
Audiology