How To Use Fractions In Excel
Bet you thought you couldn't use fractions in Excel. Well, as a matter of fact, Excel does do fractions, but at first you may find it a little tricky entering them.
If you enter 1/2 in a cell, Excel will interpret this as a date and automatically format the cell as a date.
To enter a fraction that Excel can recognize, you have to precede your fraction with a zero and a space, for example 0 1/2. Excel will now recognize this entry as a fraction, store it's decimal equivalent in the cell and format it to display as a Fraction.