Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
="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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting in the formula bar | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |