## Formula to convert number to comma separated values

=TEXT(C2,REPT("0\,",LEN(C2)-1)&0)

The Excel TEXT() function is used to convert a number into text.

The function takes **two** parameters

**1)** the "value" (or number)

**2)** the "format" text

Therefore, in the above formula the **first** parameter is the cell that has number and the **second** paramter has another function called "REPT()", which will repeat the "commas" after each number.

Here's another example of **TEXT()** function.

Let us assume I have number 14875 and I want to change the value in "0.00" format. The formula will be...

=TEXT("14875","0.00")

Or

=TEXT(A2,"0.00")

🙂