Thread: data labels to show value, label & percent

Does anyone know how to show data labels for percent, label AND the value all at once? I tried to use the concatenate formula, but it won't keep formats, such as a dollar amount containing dollar sign, comma separators and correct decimal places. Thanks

Hi,

You need to format the values within the CONCATENATE function by using
the TEXT function.
Assuming Value in A1 and % in B1 use something like,

=CONCATENATE(TEXT(A1,"$#0.00")," and ",TEXT(B1,"0.0%"))

Cheers
Andy

nihad wrote:
> Does anyone know how to show data labels for percent, label AND the
> value all at once? I tried to use the concatenate formula, but it
> won't keep formats, such as a dollar amount containing dollar sign,
> comma separators and correct decimal places. Thanks
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info