Rounding Of Concatenated Costs Field
You should've posted your formula.
Try this:
A1 = $29,501,341.16
=TEXT(A1/1000000,"$0.0\M")
--
Biff
Microsoft Excel MVP
"Caldo" wrote in message
...
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
|