Entering Fractions

You can enter a fractional number in a cell and use it for calculation:

• Enter "0 1/5" in a cell (without the quotation marks) and press the input key. In the input line above the spreadsheet you will see the value 0.2, which is used for the calculation.

If you enter “0 1/2” AutoCorrect causes the three characters 1, / and 2 to be replaced by a single character, ½. The same applies to 1/4 and 3/4. This replacement is defined in Tools - AutoCorrect - AutoCorrect Options - Options tab.

If you want to see multi-digit fractions such as "1/10", you must change the cell format to the multi-digit fraction view. Open the context menu of the cell, and choose Format cells. Select "Fraction" from the Category field, and then select "-1234 10/81". You can then enter fractions such as 12/31 or 12/32 - the fractions are, however, automatically reduced, so that in the last example you would see 3/8.