Formating syntax

[Bdavis]

I have a formula :

="Lost profits are "&ROUND(G24,0)

What the syntax to format the cell reference (G24) as a
currency with zero decimals?

Thanks in advance

 

[JohnI]

Bdavis,

try -

="Lost profits are "&TEXT(ROUND(G24,0),"$#,##0.00")

regards,

JohnI

 

[JohnI]

Bdavis,

try -

="Lost profits are "&TEXT(ROUND(G24,0),"$#,##0")

leaving out decimals this time

regards,

JohnI

 

[Bradley Dawson]

="Lost profits are " & TEXT(G24,"$#,##0")

Any formatting can be inserted as the second argument of the TEXT() function
when you want to mix some text and a number in a specific number format.