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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks