Number format

[nsv]

I have a cell containing:

="Number of combinations = "&COUNTA(C2:C1500)*COUNTA(D21500)

This number easily exceeds 1 million which makes it diffcult to read
with all the digits in one long row, so I would like to format it with
thousand-separators.
I could make the calculation in another cell e.g. C25 and then write:

="Number of combinations = "&C25

and then format C25 to thousandseparators, but that does not change the
appearance in the cell where I combine it with the text.

Is it possible to change the number format in such a case?


NSV

 

[Bob Phillips]

="Number of combinations =
"&TEXT(COUNTA(C2:C1500)*COUNTA(D21500),"#,###,##0")


--

HTH

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

 

[nsv]

It works - thanks Bob!

NSV