Number format
 

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

Number format
 

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


--

HTH

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


"nsv" wrote in message
...

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

Number format
 

It works - thanks Bob!

NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=484208