Decimals in Formula

M

Mestrella31

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
 
J

Jason Morin

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

HTH
Jason
Atlanta, GA
 
E

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
 
Top