concatenation

[pba1]

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

 

[cmhoz]

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]

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]

How about:

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