Indivisible Fraction

%3CLINGO-SUB%20id%3D%22lingo-sub-1481808%22%20slang%3D%22en-US%22%3EIndivisible%20Fraction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481808%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20I'd%20like%20to%20get%20help%20on%20writing%20fractions%20in%20excel%20cells.%20As%20we%20know%2C%20anytime%20fractions%20are%20typed%2C%20they%20are%20reduced%20to%20their%20smallest%20denominator!%20Well%2C%20I%20want%20to%20retain%20the%20fraction%20with%20no%20division%2C%20i.e%20if%20I%20type%206%2F60%2C%20I%20do%20not%20want%20it%20to%20reduce%20to%201%2F10%20or%20if%20I%20use%20a%20custom%20format%20that%20it%20won't%20just%20retain%20the%20numerator%20and%20reduce%20the%20denominator%2C%20but%20that%20it%20would%20retain%20the%20value%20or%206%2F36%2C%206%2F60%2C%206%2F120...%20Any%20helpful%20suggestions%2C%20please%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1481808%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481876%22%20slang%3D%22en-US%22%3ERe%3A%20Indivisible%20Fraction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481876%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F528567%22%20target%3D%22_blank%22%3E%40ituryu%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20solution%20I%20can%20think%20of%20is%20to%20format%20your%20cell%20as%20text.%20This%20comes%20with%20a%20huge%20drawback%2C%20you%20won't%20be%20able%20to%20use%20it%20in%20any%20calculation%20anymore.%20But%20if%20you%20don't%20need%20it%20to%20manipulate%20the%20fraction%20after%2C%20you're%20good%20to%20go.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBen%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481884%22%20slang%3D%22en-US%22%3ERe%3A%20Indivisible%20Fraction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F528567%22%20target%3D%22_blank%22%3E%40ituryu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%2060%20in%20the%20denominator%20then%20set%20the%20custom%20number%20format%20to%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%23%20%3F%3F%2F60%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hello everyone, I'd like to get help on writing fractions in excel cells. As we know, anytime fractions are typed, they are reduced to their smallest denominator! Well, I want to retain the fraction with no division, i.e if I type 6/60, I do not want it to reduce to 1/10 or if I use a custom format that it won't just retain the numerator and reduce the denominator, but that it would retain the value or 6/36, 6/60, 6/120... Any helpful suggestions, please? Thanks.

2 Replies
Highlighted

Hi @ituryu,

 

The only solution I can think of is to format your cell as text. This comes with a huge drawback, you won't be able to use it in any calculation anymore. But if you don't need it to manipulate the fraction after, you're good to go.

 

Ben 

Highlighted

@ituryu 

If you want 60 in the denominator then set the custom number format to:

# ??/60