How do you enter a fractional value in Excel?

Answer 1

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

Answer 2

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

Answer 3

In Excel 2007, right-click on the cell where you want to display a fraction and select Format Cells. In the Format Cells window, click the Number tab and select Fraction as the category. Scroll through the list of fraction options and select the format you want to use. The formatted cell will display numbers as fractions and can be used in formulas, just like any other number.

Answer 4

Enter your fraction, such as 1/2, then format the cell number as fraction, just like you would if you wanted the number to display as currency or any other number format.