Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Fraction in Excel

  • 06-07-2011 8:30pm
    #1
    Jellybaby1
    Closed Accounts Posts: 7,108 ✭✭✭


    I want to type 4½
    in a cell in Excel 97. I tried copying it from a Word document but although it went in ok, it makes the cell extend. Any advice please? I don't want to put 4.5 as 4½
    is better for my project.

    As you can see, putting it in here also doesn't work too well either as it also leaves a lot of space after it!
    Tagged:


Comments

  • #2
    rcdk1
    Closed Accounts Posts: 558 ✭✭✭rcdk1


    You can insert it as a symbol. Go to Insert>Symbol and scroll down until you find it. However, I don't have Excel here but I suspect that you may not be able to use this in a formula.

    What he said
    |
    |
    |
    V


  • #3
    Puggle
    Registered Users, Registered Users 2 Posts: 6 ✭Puggle


    Just highlight the cells and click format cells and select fraction.


  • #4
    Jellybaby1
    Closed Accounts Posts: 7,108 ✭✭✭Jellybaby1


    Thanks, but still comes out as 4 1/2. I must be doing something wrong. I have set the cells for 'text', then I typed 4 1/2, then I selected the cell and set it to 'fraction' but nothing changed.


  • #5
    Puggle
    Registered Users, Registered Users 2 Posts: 6 ✭Puggle


    Try it a second time. Dunno why but sometimes when you format cells in excel you need to do it twice to make it work.


  • #6
    rcdk1
    Closed Accounts Posts: 558 ✭✭✭rcdk1


    Jellybaby1 wrote: »
    Thanks, but still comes out as 4 1/2. I must be doing something wrong. I have set the cells for 'text', then I typed 4 1/2, then I selected the cell and set it to 'fraction' but nothing changed.
    Assuming the cell is unformatted, type your number as a decimal i.e. 4.5 and then format it to fraction.


  • Advertisement
  • #7
    Jellybaby1
    Closed Accounts Posts: 7,108 ✭✭✭Jellybaby1


    Puggle wrote: »
    Try it a second time. Dunno why but sometimes when you format cells in excel you need to do it twice to make it work.

    Still got 4 1/2
    rcdk1 wrote: »
    Assuming the cell is unformatted, type your number as a decimal i.e. 4.5 and then format it to fraction.

    And again, 4 1/2

    I'm using Excel 97, maybe it doesn't have this particular function. Time to give up I think. Thanks for your help anyway.


  • #8
    im invisible
    Closed Accounts Posts: 4,372 ✭✭✭im invisible


    if you're not using it in formulas/ totals etc. to get a text representation turn on num lock, hold down alt and type 171, for 1/2 (dosnt seem to be working on boards, so may not work) or 172 for 1/4, cant do other fractions

    edit, i think you may have coppied the 'new line' aswell as the ½ from word???


  • #9
    Jellybaby1
    Closed Accounts Posts: 7,108 ✭✭✭Jellybaby1


    im invisible wrote: »
    if you're not using it in formulas/ totals etc. to get a text representation turn on num lock, hold down alt and type 171, for 1/2 (dosnt seem to be working on boards, so may not work) or 172 for 1/4, cant do other fractions

    edit, i think you may have coppied the 'new line' aswell as the ½ from word???

    Omigosh that worked! Thanks so much. Where can I find more info on the other fractions? Don't know if I did copy the new line, I might have though.


Advertisement