How can I keep a fraction from being reduced?

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.

On Thu, 10 Nov 2005 07:30:35 -0600, rdmdale
<[email protected]> wrote:

>
>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

Format>Cells>Number>Fraction>As tenths

--
Kind regards,

Niek Otten

"rdmdale" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> rdmdale
> ------------------------------------------------------------------------
> rdmdale's Profile:
> http://www.excelforum.com/member.php...o&userid=27339
> View this thread: http://www.excelforum.com/showthread...hreadid=483889
>

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))

"rdmdale" wrote:

>
> 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.
>
>
> --
> rdmdale
> ------------------------------------------------------------------------
> rdmdale's Profile: http://www.excelforum.com/member.php...o&userid=27339
> View this thread: http://www.excelforum.com/showthread...hreadid=483889
>
>