Decimals in Formula
 

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

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

.

Trella,

Here's a way that maintains the value in the cell (not a string that
includes "This totals..." So another formula can refer to it, if necessary,
to get the value.

Put this in the cell:
=ROUND(SUM(G28:G32),2)

Format (Format - Cells - Number - Custom):
"This totals need to consider" #,##0.00

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Mestrella31" wrote in 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