Rounding Of Concatenated Costs Field
Hi,
I never get to use that function - nice.
You can shorten it to
=DOLLAR(D6/10^6,1)&"M"
because order of presidence is ^ before * or /.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Teethless mama" wrote:
=DOLLAR(A1/(10^6),1)&"M"
"Caldo" wrote:
The second field in my concatenate function is actual costs, the first is
line of business. One value, for example, is $29,501,341.16 which I can round
down to $29,501,341 but the concatenated value is fully exploded with the
decimals. What I ideally would like to do is have the concatenated value read
$29.5M. Any ideas? Excel 2007
|