Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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, "0.25" is displayed as "4/16" and not as "1/4."

↑ Back to the top

Workaround

To work around this issue, convert the decimal values by using a formula that is similar to the following:
=TEXT(A1,"#"&IF(ABS(A1-ROUND(A1,0))>1/32," 0/"&CHOOSE(ROUND(MOD(A1,1)*16,0),16,8,16,4,16,8,16,2,16,8,16,4,16,8,16),""))
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.

↑ Back to the top

Status

This behavior is by design.

↑ Back to the top

References

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
264372� How to control and understand settings in the Format Cells dialog box in Excel

↑ Back to the top

Keywords: KB893691, kbprb, kbtshoot

↑ Back to the top

Article Info
Article ID : 893691
Revision : 4
Created on : 11/10/2006
Published on : 11/10/2006
Exists online : False
Views : 369