Forrmula Formatting question...
 

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

Forrmula Formatting question...
 

="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

Forrmula Formatting question...
 

Try this:

="Cost of Additional 1% "&TEXT(SUM(K3:K17),"$ 0.00")

HTH,
Elkar


"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