# concatenation

#### pba1

##### New Member
I can't believe I'm asking this as it seems so simple but I can't seem to get a concatenated formula to display a value as percent. It always returns a decimal even if the source data is a percentage. This is the formula. It is set up to produce a decimal in this form but I would like the F135 value to display as a %
CONCATENATE(D134 &"( " & ROUND(F134,2) & " )")
Thanks
P

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### cmhoz

##### Active Member
You could try using the TEXT function around your concatenate:

=text(CONCATENATE(D134 &"( " & ROUND(F134,2) & " )"),"##%")

You'll have to play with the format code at the end depending on the kind of number the concatenate brings back (eg: concatenate = 35, then using "##%" will bring back 3500%)

and... if you need to be able to do math with it, just add another function:

=value(text(CONCATENATE(D134 &"( " & ROUND(F134,2) & " )"),"##%"))

#### pba1

##### New Member
Thanks. The suggested form didn't work but It did lead me to trying a different form that did work. as I am now working in text the round function could be eliminated and the number of digits after the decimal can be controlled by the form of the % espression.
CONCATENATE(D134 &" ( " & TEXT(F134,"0.0%") & " )")
Peter

#### Scott Huish

##### MrExcel MVP

=D134&TEXT(F134," (0.0%)")

Replies
1
Views
132
Replies
9
Views
535
Replies
2
Views
152
Replies
2
Views
148
Replies
3
Views
530

1,136,702
Messages
5,677,290
Members
419,684
Latest member
BOB101

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back