Formating syntax

  • Thread starter Thread starter Bdavis
  • Start date Start date
B

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
 
Bdavis,

try -

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

leaving out decimals this time :-)

regards,

JohnI
 
="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.
 
Back
Top