="This totals need to consider "&TEXT((ROUND(SUM
(G28:G32),2)),"#,###.00")

HTH
Jason
Atlanta, GA

-----Original Message-----
how do I turn This:
="This totals need to consider "&(ROUND(SUM(G28:G32),2))

Into This:
This totals need to consider 171,150.00

And Not
This totals need to consider 171150.00

.