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
CONCATENATE(D134 &"( " & ROUND(F134,2) & " )")
Thanks
P