Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    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.

    Thanks in advance,
    Richard Spring

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    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
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    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. #4
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you RG and Steve.

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

    Thanks for the quick reply.
    Richard Spring

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •