Results 1 to 11 of 11
  1. #1
    Lounger
    Join Date
    Oct 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Displaying fractions in Excel

    Is there a way if displaying a fraction in Excel in a better way than just '6 1/2' (6.5) ,
    eg. putting the vulgar fraction in smaller letters than the main number?
    Excel 2000

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    You mean like this?
    1/2 is CHR189 - are you looking for an infinite range - or just the quarters?
    (188= 1/4, 190 = 3/4)
    Attached Images Attached Images
    • File Type: gif x.gif (519 Bytes, 6 views)

  3. #3
    Lounger
    Join Date
    Oct 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    How do you do that?


    [img]/S/bow.gif[/img]

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    I think Word only does it a with a limited number of fractions, like the quarters and half and it seems to use the extended characters that Leif referred to. They can be used but will treated like text by Excel. to enter a half, Hold down the ALT key and enter 0189 on the numeric keypad. Doing that you are entering text, not a number.

    If you want to format your numbers and results as proper fractions, then the answer appears to be no.



    Andrew C

  5. #5
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    How did I insert the fraction?
    I cheated. Went to Word, insert symbol, copy'n'paste. [img]/S/smile.gif[/img]

    If you want to make it auto-correct (how I did it):
    In Word, type '1/2' - which is converted to

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    These symbols presumably do not evaluate to the values that they show, and so could not be used in formulas etc.

    Maybe I am incorrect but I would assume that the formatting is required for numerical data.

    Andrew C

  7. #7
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    Very true.
    But if it is only for cosmetic reasons, it may do the job - though who would want to use some of those fractions is beyond me.

  8. #8
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    If you have the MS Reference 2 font installed, you have access to a whole range of fractions.
    Attached Images Attached Images
    • File Type: png x.png (4.0 KB, 1 views)

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    Actually, Word does it better than you can do with Excel. Using Word's equation editor, you can create an fraction you want, and with a horizontal line vs the slanted line.
    Legare Coleman

  10. #10
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    The equation editor objects can be embedded in Excel also, put not to format Excel data. It is purely cosmetic.

    Andrew C

  11. #11
    Star Lounger
    Join Date
    Dec 2000
    Location
    Tacoma, Washington, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying fractions in Excel

    Just Format the cell using Fraction style. You have a choice of detail. The roll your own form is # ???/???.
    <IMG SRC=http://www.wopr.com/w3tuserpics/DougKlippert_sig.jpg>

Posting Permissions

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