Format a concantated text string

[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

 

[Dkso]

Thank you!

Dean

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)

 

[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)

 

[Max]

Just to add on a little ..

Think Debra Dalgleish provides some examples at her:
http://www.contextures.com/xlCombine01.html
Scroll down to "Formatting Examples"

And we could also discover the "type" by say, clicking on a cell
pre-formatted as currency, then do a Format > Cells > Custom to see/copy
what appears inside the "Type:" box [to paste as the "format_text" inside
the TEXT(...)]