Microsoft KB Archive/893691

= Decimals that are displayed as rounded 1/16th fractions are not reduced to the simplest form in Excel 2007 and in Excel 2003 =

Article ID: 893691

Article Last Modified on 11/10/2006

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-





SYMPTOMS
When you try to display a decimal value in sixteenths by using the Fraction formatting category and the As sixteenths type, the fractions are not reduced to their simplest form. For example, &quot;0.25&quot; is displayed as &quot;4/16&quot; and not as &quot;1/4.&quot;



WORKAROUND
To work around this issue, convert the decimal values by using a formula that is similar to the following:

=TEXT(A1,&quot;#&quot;&IF(ABS(A1-ROUND(A1,0))>1/32,&quot; 0/&quot;&CHOOSE(ROUND(MOD(A1,1)*16,0),16,8,16,4,16,8,16,2,16,8,16,4,16,8,16),&quot;&quot;))

This formula converts a decimal value in A1 to an integral fraction that is expressed to the nearest sixteenth. Additionally, this formula displays the fraction in its simplest form in the cell that contains the formula.



STATUS
This behavior is by design.

