Please Help...

T

Tibbets

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.
 
D

Dave Peterson

You have a reply at your post in .misc.
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.
Click to expand...
 
B

Bob Phillips

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top