="Cost of Additional 1% "& text(SUM(K3:K17),"$0.00")
(or whatever format you want)
Tibbets wrote:
Ok here is the formula:
="Cost of Additional 1% "& SUM(K3:K17)
I am trying to get the Sum piece to show as currency. Any help is
appreciated.
--
Tibbets
------------------------------------------------------------------------
Tibbets's Profile: http://www.excelforum.com/member.php...o&userid=33736
View this thread: http://www.excelforum.com/showthread...hreadid=535133
--
Dave Peterson