How to Concatenate with a 2-Decimal Percent Result?

Thanks:  0
Likes:  0

# Thread: How to Concatenate with a 2-Decimal Percent Result?

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.

Thank you!

## User Tag List

#### Posting Permissions

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