Results 1 to 5 of 5

How to Concatenate with a 2-Decimal Percent Result?

This is a discussion on How to Concatenate with a 2-Decimal Percent Result? within the Excel Questions forums, part of the Question Forums category; How do I use concatenate to produce a 2-decimal point percentage figure, for instance ="The Percentage is " & A1/A2, ...

  1. #1
    New Member dovabrams's Avatar
    Join Date
    Jun 2006
    Posts
    10

    Default How to Concatenate with a 2-Decimal Percent Result?

    How do I use concatenate to produce a 2-decimal point percentage figure, for instance ="The Percentage is " & A1/A2, where A1/A2 is the percentage?

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,002

    Default Re: How to Concatenate with a 2-Decimal Percent Result?

    Like this:

    ="The percentage is "&TEXT(A1/A2,"0.00%")

  3. #3
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,260

    Default Re: How to Concatenate with a 2-Decimal Percent Result?

    Try

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

  4. #4
    Board Regular
    Join Date
    Aug 2003
    Location
    England
    Posts
    4,644

    Default Re: How to Concatenate with a 2-Decimal Percent Result?

    Try

    ="the percentage is "&A1/A2%&"%"

    must learn to read the question properly.
    must learn to read the question properly.
    must learn to read the question properly.
    must learn to read the question properly.
    must learn to read the question properly.
    -------------------------
    Hope this is helpful.
    -------------------------
    only a drafter,
    but broadening my Excel knowledge.

  5. #5
    New Member dovabrams's Avatar
    Join Date
    Jun 2006
    Posts
    10

    Default Re: How to Concatenate with a 2-Decimal Percent Result?

    Thank you!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com