Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Formatting Numbers > Fraction Format< Previous | Next > 

 

Step 1 - Understanding the Format

 
 

This format displays decimal numbers as actual fractions.

 
   
 

For more details about entering and displaying fractions, please refer to the Displaying Fractions page.

 
 

All numbers are rounded to the nearest single digit fraction.

 

 

Step 2 - Up to one digit (1/4)

 
   

 

Step 3 - Up to two digits (21/25)

 
   

 

Step 4 - Up to three digits (312/943)

 
   

 

Step 5 - As halves (1/2)

 
   

 

Step 6 - As quarters (2/4)

 
   

 

Step 7 - As eighths (4/8)

 
   

 

Step 8 - As sixteenths (8/16)

 
   

 

Step 9 - As tenths (3/10)

 
   

 

Step 10 - As hundredths (30/100)

 
   

 

Step 11 - Things to Remember

 
 
  • All numbers are rounded to the nearest single digit fraction.

     

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >