Decimals in Formula

[Guest]

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

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[Earl Kiosterud]

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