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.