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.


--
rdmdale
------------------------------------------------------------------------
rdmdale's Profile: http://www.excelforum.com/member.php...o&userid=27339
View this thread: http://www.excelforum.com/showthread...hreadid=483889

How can I keep a fraction from being reduced?
 

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

How can I keep a fraction from being reduced?
 

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

How can I keep a fraction from being reduced?
 

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