Microsoft Excel 2007 tutorial: format numbers as fractions

Format numbers as fractions

V. Format numbers as fractions

You can display or type numbers as actual fractions instead of decimals by using the  Fraction format. You can format the numbers in a cell, range of cells, multiple nonadjacent cells, or ranges of cells all at once. To format the numbers, do the following:

- On the worksheet, select the cells, range of cell, multiple nonadjacent cells, ranges of cells that you want to format.

- On the Home tab, in the Number group, do one of the following:

  To format the numbers with a default fraction (Up to one digit (1/4)), click drop-down arrow of the Format Number box, and then click Fraction in the list.

  Excel 2007 Fraction format

  To display the numbers as a fraction that you can select the fraction type from the list, click drop-down arrow of the Number Format box, and then click More Number Formats or click Dialog Box Launcher next to Number.

  Excel 2007 More Number Formats  Excel 2007 Dialog Box Launcher

 In the Format Cells dialog box, in the Category box, click Fraction. Select the fraction type that you want to use in the Type list, and then click Ok button to apply this format.

 Excel 2007 fraction types


- All available fraction formats are in the Type list of the Fraction, in the Format Cells dialog box.

- When you select the number in the active cell, it displays in the Sample box so that you can preview the number with the format options that you select.

- After you apply a fraction format to a cell, decimal numbers or actual numbers that you enter in that cell will be displayed as a fraction. For instance, you type .4 or 2/5, the result will be 2/5 when the cell has been formatted as Up to one digit fraction type.

- If a cell is not applied with a fraction format, and you enter a fraction such 2/5 in that cell, the fraction will be formatted as date (5- Feb). To format it as a fraction, click Fraction in the Number Format box, and then reenter the fraction.

- If you don't want a cell performing a calculation on fraction, you can format that cell as text before you type a fraction in by clicking drop-down arrow of the Number Format box, and then clicking Text, or clicking Text in the Category box of the Format Cells dialog box. Note that the fractions are formatted as text cannot perform mathematical calculations.

- To reset the number format, do the following:

1. Select the cells that you want to clear the format.

2. Click General in the Number Format box, in the Number group of the Home tab or in the Category box, on the Number tab of the Format Cells dialog box.



This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.