How can I keep a fraction from being reduced?

[rdmdale]

I have a formula that divides the numbers in two cells. The result is
displayed as a fraction. How can I keep the fraction from being
reduced?
i.e. I DON'T want 5 5/10 reduced to 5 1/2; I want it displayed as 5
5/10.

Thanks.

 

[Ron Rosenfeld]

I have a formula that divides the numbers in two cells. The result is
displayed as a fraction. How can I keep the fraction from being
reduced?
i.e. I DON'T want 5 5/10 reduced to 5 1/2; I want it displayed as 5
5/10.

Thanks.

Custom Format as # ??/10

Format/Cells/Number Custom Type: # ??/10


--ron

 

[Niek Otten]

Format>Cells>Number>Fraction>As tenths

 

[Guest]

The above options work if you want everything in tenths. If you use their
format you might get errors because it rounds everything to tenths as well
(ie for 1/3 you get 3/10). Otherwise you will have to use this formula. I
assumed you divided 55 by 10.

=TEXT(A1/A2,"# #/"&A2)
or
=INT(A1/A2)&" "&MOD(A1,A2)&"/"&A2

Ex1:
A1: 56
A2: 12
A3: 4 8/12

It formats the result as text, but you can still use the result as a number
in other cells. For instance...

A4: =A3+2
Results as 6.666666

To get A4's result as 6 8/12 you need another formula.
=TEXT(A3+2,"# #/"&A2)
or
=2+INT(A3)&" "&RIGHT(A3,LEN(A3)-FIND(" ",A3))