How do I force a comma between two 4 digit numbers?

[nyancat]

I want to put a comma between two numbers in a cell without a space, for example: 3055,2666

I tried using the custom cell format to force the separation but it didn't work. The comma keeps on separating the numbers into 30,255,666

Any ideas?

 

[Rick Rothstein]

I want to put a comma between two numbers in a cell without a space, for example: 3055,2666

I tried using the custom cell format to force the separation but it didn't work. The comma keeps on separating the numbers into 30,255,666

Any ideas?

Give this Custom Cell Format a try...

0000\,0000

 

[Jim885]

Assuming your data is in cell A1, try this formula in another cell ...
=LEFT(A1,4)&","&RIGHT(A1,4)