Patrick’s Bytes

Techie for the past 30 years…

Enter a Fraction in a Cell in Excel 2007

To enter a fraction, simply prefix it with a zero and a space. So to display the fraction one-third, type 0 1/3. This will display 1/3 but will have an underlying value of 0.33333333.