# 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 " &amp; A1/A2, ...

1. ## 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. ## Re: How to Concatenate with a 2-Decimal Percent Result?

Like this:

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

3. ## Re: How to Concatenate with a 2-Decimal Percent Result?

Try

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

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

5. ## Re: How to Concatenate with a 2-Decimal Percent Result?

Thank you!

#### Posting Permissions

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