You can "freeze" the denominator with a custom format like:

# ?/72
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"IKDairo" wrote in message
...
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.