answersLogoWhite

0

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

12y ago

What else can I help you with?

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.


How can I accurately determine the value of my fractional shares using a fractional shares calculator?

To accurately determine the value of your fractional shares using a fractional shares calculator, input the total number of shares you own, the current market price of the stock, and the fraction of a share you have. The calculator will then calculate the value of your fractional shares based on these inputs.


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

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


How can I accurately determine the value of my fractional shares using a fractional share calculator?

To accurately determine the value of your fractional shares using a fractional share calculator, input the total number of shares you own, the current market price of the stock, and the fraction of a share you own. The calculator will then calculate the value of your fractional shares based on these inputs.


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.