Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    London, Gtr London, England
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Top heavy fractions (Excel 2000)

    Hi! How do you get excel to show top heavy fractions - 3/2 for example? It wants to convert them to a date "3 Feb 2006" for a Brit like me!

    Regards

  2. #2
    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

    Re: Top heavy fractions (Excel 2000)

    You must enter it with an equal sign so it knows that it is a number:
    =3/2

    It will normally display as 1.5 then (if formatted as general). Format as custom 0/2 and it will be the number 3/2 (=1.5) which can be used in calculations.

    Steve

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Top heavy fractions (Excel 2000)

    In case you are not wanting to have it viewed as a decimal, you can convert it to text by putting a single inverted comma in front of the 3/2

    Like so <big><big>' 3/2</big></big> you will now see it as <big><big>3/2</big></big>
    Jerry

  4. #4
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    London, Gtr London, England
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Top heavy fractions (Excel 2000)

    Thanks very much for that, Steve. I'm all set!

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    London, Gtr London, England
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Top heavy fractions (Excel 2000)

    Thanks Jezza!

Posting Permissions

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