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 instead of 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.