Replace what's right of the equals sign with

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


--
Regards,

Peo Sjoblom


"Brad" wrote in message
...
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?