Thread: Please Help...
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Please Help...

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tibbets" wrote in
message ...

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