Share via

Entering number and % in one cell

Anonymous
2010-07-03T13:26:24+00:00

Can I have a a number and a percentage in a single cell

For example: if I have 10 apples out of a total of 50 can it be displayed in a single cell with excel calculating the percentage automatically and putting it in brackets so it displays as follows

10 (20%)

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2010-07-03T13:32:32+00:00

    Hi,

    You can do it like this

    =A2 &" ("&(A2/A1)*100 &"%)"

    Whare

    A1= 50

    A2= 10

    EDIT. For an alternative

    =A2&" "&TEXT(A2/A1,"(##.00%)")

    If this post answers your question, please mark it as the Answer.

    Mike H

    50+ people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-07-03T23:19:50+00:00

    Can I have a a number and a percentage in a single cell

    For example: if I have 10 apples out of a total of 50 can it be displayed in a single cell with excel calculating the percentage automatically and putting it in brackets so it displays as follows

    10 (20%)

    =A6 & TEXT(A6/A7," (0%)")

    Note that this is text.  It is suitable for presentation, but not for dependent calculation.

    3 people found this answer helpful.
    0 comments
  2. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2017-09-12T23:37:45+00:00

    Hi,

    Try this

    =A2 &" ("&TEXT((A2-A1)/A1,"0.00%")&")"

    Hope this helps.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2011-01-08T13:59:16+00:00

    How do you do it in two columns?

    0 comments
  4. Anonymous
    2010-07-03T13:58:39+00:00

    I wouldn't do this.

    It's gonna make every other calculation (that you have now or that you think of

    in the future) much more difficult.

    I'd use two separate columns.

    John, Davies wrote:

    Can I have a a number and a percentage in a single cell

    For example: if I have 10 apples out of a total of 50 can it be displayed in a single cell with excel calculating the percentage automatically and putting it in brackets so it displays as follows

    10 (20%)

    Thanks

    --

    Dave Peterson

    0 comments