answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

βˆ™ 11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

βˆ™ 11y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

βˆ™ 14y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

βˆ™ 14y ago

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.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you enter a fractional value in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When you enter a date excel assigns a what value to the date?

numerical


When you enter a date Excel assigns a?

a serial value to the date


What truncates the fractional part?

In Excel, it is the function ROUNDDOWN.


Every time you enter a value into a cell in the work excel automatically does what to formulas?

recalculates all formulas


What is the name of the Excel feature that recalculates formulas every time you enter a value into a cell?

auto-calculate


How do you enter same value in every cell in Excel in mac entourage?

There is no direct connection between Excel and Entourage, but if you highlight all the cells from Excel and go to Entourage, you should be able to paste the data.


What are Error And Input Messages Excel?

When using the Validation facility you can set an Input message to tell the user what they should enter like "Enter a value between 1 and 100". You can set an Error message to show if they do not enter a value that is valid.


An element in the excel window that displays the value or formula contained in the active cell in which you can enter or edit values from is?

The Formula Bar.


Which excel formula will compute the midpoint value in a range?

Median( number1, number2, ... number_n )You may enter up to 30 values


How do you work out percentage out on excel?

Enter the percent in one column, enter the other value in another column. In a third column tell excell to multiply the 2 columns and divide by 100.


How you enter account no in Excel sheet it not except?

This question is not clear. You can enter a number in Excel by clicking on a cell and typing the number from the keyboard.


When you enter a date excel assigns a value?

This is a true statement, but is not a question. Ask again using words that make it clear what you want to know.