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

[nsv]

I have a cell containing:

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

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(D2:D1500),"#,###,##0")


--

HTH

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


"nsv" <[email protected]> wrote in message
news:[email protected]...
>
> I have a cell containing:
>
> ="Number of combinations = "&COUNTA(C2:C1500)*COUNTA(D2:D1500)
>
> 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
>
>
> --
> nsv
> ------------------------------------------------------------------------
> nsv's Profile:
http://www.excelforum.com/member.php...o&userid=26500
> View this thread: http://www.excelforum.com/showthread...hreadid=484208
>

[nsv]

It works - thanks Bob!

NSV