![]() |
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 > |