1. ## Fractions in Excel

I know that you can enter a fraction in excel by typing a leading "0" and space before the fraction. This allow it to be a number that can be used in calculations and not just as text. For example the fraction 3/5 would be entered as "0 3/5" (Note the space between 0 and 3).

My question is how do you enter a measurement such as 20 3/5 inches as a number? Is this possible and how is it accomplished.

2. Richard,

I just tried it in Excel 2010 on a clean worksheet and it works just fine if you enter 20 3/5.
If I then enter 0 2/5 in the next cell and then add them in the third cell I get 21.
Is it possible you are trying to enter fractions into cells that are already formatted? HTH

3. I agree with the RetiredGeek. If I enter in 20 3/5, excel automatically enters the value 20.6 into the cell and changes the format it to display "20 3/5" (# ?/? = Fraction with 1 digit).

If the cell is already formatted, the number still gets converted, but it retains the formatting that was entered instead of converting to a fraction.

Steve

4. Thank you RG and Steve.

I did not notice the number in the Fx box. Must be the old thing creeping in again.