Entering fractions in Excel

If you enter 1/2 into an Excel document the program will assume it's a date and convert it to 02-Jan. To prevent this, enter the fraction as 0 1/2. Now the cell will display ½, and the formula bar will display 0.5.