Data labels formatting

[#1]

Hi all!

How do I make the data labels show $19.8 M, $18.9 M, and $15.5 M?  I can get them to say $19M, $18M, and $15M, but can't figure out how to add the decimal.

Thanks!

[sinanozdemir]

Hi,

This is what I used:

Hope this helps.

Thanks

[MarcoWedel]

Hi,

one solution might be also:

=Dual(Num(Sum(Value)/Pow(10,3*Div(Log10(Sum(Value)),3)),'$#,##0.0')&' '&Pick(Div(Log10(Sum(Value)),3),'K','M','B','T'),Sum(Value))

hope this helps

regards

Marco