Concantenant and % but shows actual number
 

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

Concantenant and % but shows actual number
 

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" wrote:

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

Concantenant and % but shows actual number
 

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%")

--
Daryl S


"Hager" wrote:

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