Here is one way to display percentages and numbers together in one column that are currently stored in separate columns on a worksheet, its a neat little trick I used recently when I had to display both a number value as well as it’s corresponding percentage value in the same text box on a diagram in Excel. All I needed to do was join or ‘concatenate’ the two values into one column then reference the text box to that column cell. The result was a nice, neat annotated diagram.
If you want to learn the basics about Concatenate?. You can do so right HERE!
If you want to jump right in and look at joining together a number and a percentage then the syntax of the formula looks something like this:-
See it in action in my example below
Give this one a go- let me know how you get on.