Like this:
="The percentage is "&TEXT(A1/A2,"0.00%")
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, ...
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?
Like this:
="The percentage is "&TEXT(A1/A2,"0.00%")
Try
="Percentage is " & TEXT(A1/A2,"0.00%")
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.
-------------------------
Have been away from the forum for quite a while, but am now back.
Thank you!
Like this thread? Share it with others