How to add a comma to the results of this formula

[PETRODATAjames]

How to add a comma to the results of this formula?
I would like to see the results in column E to have a comma added after the number, e.g. E4 27460, E5 12196, E6 49064, and so on.

Thanks

 

[arthurbr]

Perhaps

=TEXTJOIN("",TRUE,yourformulahere,",")

 

[JamesCanale]

Custom formatting too.

0","

on the cells in question.

MrExcelPlayground19.xlsx
	AM	AN
18	30087,	32981,
19	19146,	37890,
20	48322,	41911,
21	44852,	21524,
22	42176,	38357,
23	11121,	20966,
24	48978,	37674,
25	19441,	47740,
26	27927,	33346,
27	25441,	30049,
28	23864,	12877,
29	40364,	38619,
30	29210,	32452,
31	20875,	21489,
32	28430,	40797,
33	43473,	19481,
34	21272,	40337,
35	18317,	30907,
36	14166,	35699,
37	23995,	41483,
Sheet2

Cell Formulas
Range	Formula
AM18:AM37	AM18	=INDEX(UNIQUE(RANDARRAY(50,1,10000,49999,TRUE)),SEQUENCE(20))&","
AN18:AN37	AN18	=INDEX(UNIQUE(RANDARRAY(50,1,10000,49999,TRUE)),SEQUENCE(20))
Dynamic array formulas.

 

[Fluff]

How about

=INDEX(UNIQUE(RANDARRAY(C4^2,,C5,C6,1)),SEQUENCE(C4))&","

Although they will no longer be numbers.