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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concantenate which keeps bold of some parts. 5
Concantenate - another level 3
format a number appearing in a text formula 2
How do I change the number format within the concantenate function 2
Concantenate Text with numbers with fixed form 2
Concantenate Text Fields in a Report Control 2
Query or Report? Need to get addresses by odd or even numbers 10
Concantenating Text with | and ' (vertical slash and single qoute) 3

Back
Top