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

On Thu, 10 Nov 2005 07:30:35 -0600, 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.

Custom Format as # ??/10

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


--ron

FormatCellsNumberFractionAs tenths

--
Kind regards,

Niek Otten

"rdmdale" wrote in
message ...

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