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