Formatting Fractions

[IKDairo]

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.

 

[RagDyeR]

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

# ?/72
--

HTH,

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

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.

 

[John C]

Assuming your numerator is in G6, and denominator is in G7.
=QUOTIENT(G6,G7)&" "&MOD(G6,G7)&"/"&G7
If your fractions will never have whole numbers, and always be less than 1,
you can shorten the formula to
=MOD(G6,G7)&"/"&G7

Say this is in G11. If you ever need to refer to the value of of G11 (i.e.:
G11 is a text that, in your example would be 0 36/72 or 36/72 if the second
option above is taken, but the value is 0.5), you can use the -- in front of
the cell during calculations.
e.g.: =--G11+H11

 

[IKDairo]

Thanks! Works perfectly

Assuming your numerator is in G6, and denominator is in G7.
=QUOTIENT(G6,G7)&" "&MOD(G6,G7)&"/"&G7
If your fractions will never have whole numbers, and always be less than 1,
you can shorten the formula to
=MOD(G6,G7)&"/"&G7

Say this is in G11. If you ever need to refer to the value of of G11 (i.e.:
G11 is a text that, in your example would be 0 36/72 or 36/72 if the second
option above is taken, but the value is 0.5), you can use the -- in front of
the cell during calculations.
e.g.: =--G11+H11