Format Result of a Formula Combining Text & Numbers

B

Brad

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?
 
P

Peo Sjoblom

Replace what's right of the equals sign with

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