concatenation

pba1

New Member
Joined
Oct 17, 2006
Messages
14
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
Joined
Aug 20, 2006
Messages
268
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
Joined
Oct 17, 2006
Messages
14
Thanks. :biggrin: 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
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
How about:

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

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top