Display Fraction

Custom entry

By Neale Blackwood

Ever needed to display a fraction in a cell and have it used in calculations? Well you can achieve that fairly easily by entering a zero and a space before entering the fraction.

Entering “0 3/4” in a cell will display 3/4 and use 0.75 in calculations. (Note there is a space between the 0 and the 3).

You can also display existing numbers as fractions by using the Fraction category in the Number tab of the Format dialog.