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

Excel question about %

  • 10-08-2015 3:00pm
    #1
    parc
    Registered Users, Registered Users 2 Posts: 796 ✭✭✭


    Hi there

    I had to paste a % from one sheet to the other. It's in percentage format (ie 25%) but I need to get it to just read 25.

    The problem is if I make it 'general' or a 'number' then it reads 0.25143

    How do I get it to just read 25

    Thanks in advance!


Comments

  • #2
    Pullover
    Registered Users, Registered Users 2 Posts: 24 ✭Pullover


    Format the cell, change it to number or general and change the number of decimal places to zero.


  • #3
    hardCopy
    Registered Users, Registered Users 2 Posts: 5,969 ✭✭✭hardCopy


    The right function can be used to give you the two right most digits i.e. '25'

    Where A1 = 0.25, use
    RIGHT(A1,2)

    EDIT: Forget that, you may as well just multiply by 100


  • #4
    homer911
    Registered Users, Registered Users 2 Posts: 5,163 ✭✭✭homer911


    Fill the target cells with 100 and then Copy > Paste Special > Multiply


Advertisement