View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Format Result of a Formula Combining Text & Numbers

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?