Format Result of a Formula Combining Text & Numbers

[Guest]

Trying to create a formula that concatenates text and an calculated
percentage.

=CONCATENATE("Percent Change"," = ",(ROUND(((E$28-B$28)/B$28),2)))

I want the result to output:

Percent Change = 1.0%

not

Percent Change = 0.01

How do I get the calculated percentage to show as a percent?

 

[Peo Sjoblom]

Replace what's right of the equals sign with

TEXT(ROUND(((E$28-B$28)/B$28),2),"0.00%")

 

[Guest]

try
="Percent Change = "&text((E$28-B$28)/B$28."0.0%")

 

[Guest]

Thanks Peo that did the trick!

Replace what's right of the equals sign with

TEXT(ROUND(((E$28-B$28)/B$28),2),"0.00%")