How can I have Excel show my numbers as fractions without simplying the
fraction? For example, if I have 72 clients, 36 of whom have renewed
services, I was Excel to show the fraction as 36/72 and not as 1/2. But I
want this number to be in a form where it automatically updates from a
separate list and can be used for automatically calculating other variables.
I can do the list couple steps when the cell is formatted as a fraction, but
I can't figure out how to keep my fraction from simplifying.