Format a concantated text string

D

Dkso

Sorry if this is boring but I'm stuck.


I have a cell that counts something, it also has a piece of text at the
front of the count but I want the count to be formatted as currency and
it won't.


="Major "&COUNTIF(C:C,"Major")*245
I've tried ="Major "& Format(COUNTIF(C:C,"Major")*245****) but I can't
get it right and think it's a VBA command!


Help please!


Thanks
Dean
 
D

Dkso

Thank you!

Dean
Bob Phillips said:
Depends upon the currency, but something like

="Major "&TEXT(COUNTIF(C:C,"Major")*245,"$#,##0.00")

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
B

Bob Phillips

Depends upon the currency, but something like

="Major "&TEXT(COUNTIF(C:C,"Major")*245,"$#,##0.00")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top