Concantenant and % but shows actual number

  • Thread starter Thread starter Hager
  • Start date Start date
H

Hager

I have a spread sheet with a large number of categories and a corresponding %.

I want to concantenant the heading and the attached % in an additional
column. So far so good but when I concantenant the % any value other than 0%
reverts to the full number below. So 5% displays as .05687899797897 (or what
ever number sits underneath)

Is there a way of getting it to display as a percentage. Ultimately I want
to import it to Visio (so the same problem may occur!).

Any help appreciated

Hager
 
as an example...assuming a1 has your percentage and a2 has your heading,
would something like this work for you...

=A2&" "&(ROUND(A1,2))*100&" %"
 
Hager -

In your concatenate, use the TEXT function to format the percent any way you
want. For example, if you want no decimal places, use this:

TEXT(B4,"0%")
 
Back
Top