# How do I format numbers to put a comma after every 4 digits

1. ## How do I format numbers to put a comma after every 4 digits

I need to list 4 digit numbers in each section followed by commas, but whatever i do it goes to 3digits (eg. I need "1234,5678,9123" and as soon as I hit Enter it goes to "123,456,789,123"). It wont help to format as text because I have a whole bunch of 12 digit numbers to break up into 4.

2. ## Re: How do I format numbers to put a comma after every 4 digits

Hi
Not sure if this will help but if you format your number in cell A1 to text initially. Then in B1 use this formula it will display as you are asking:

=MID(A1,1,4)&","&MID(A1,5,4)&","&MID(A1,9,4)

Once you have done that you can copy column B and choose paste value in the same column which will display as you want.
Good luck.
Tony

3. ## Re: How do I format numbers to put a comma after every 4 digits

Perhaps custom format as ###,###,###,###

4. ## Re: How do I format numbers to put a comma after every 4 digits

@pepe Le Mokko, I need every 4 digits that only helps for 3 digits
@argk I dont understand

5. ## Re: How do I format numbers to put a comma after every 4 digits

Hi
Format cell A1 as text.
Enter a 12 digit number in A1.
Put the formula in cell B1.
The number is now displayed in your requested format.
Tony

6. ## Re: How do I format numbers to put a comma after every 4 digits

Format as #\,####\,####

It's not perfect:

 A 1 1234,5678,9123 2 123,4567,8912 3 12,3456,7891 4 1,2345,6789 5 ,1234,5678 6 ,123,4567 7 ,12,3456 8 ,1,2345 9 ,,1234 10 ,,123 11 ,,12 12 ,,1

7. ## Re: How do I format numbers to put a comma after every 4 digits

If they are always 12-digit numbers then you can use this in B1:

=LEFT(A1,4)&","&MID(A1,5,4)&","&RIGHT(A1,4)

and copy down.

Hope this helps.

Pete

8. ## Re: How do I format numbers to put a comma after every 4 digits

[QUOTE=Itstaken1;3439009]@pepe Le Mokko, I need every 4 digits that only helps for 3 digits
Well then ####,####,####

9. ## Re: How do I format numbers to put a comma after every 4 digits

@Pepe,

No, that doesn't work.

Pete

10. ## Re: How do I format numbers to put a comma after every 4 digits

Hi
See sample using the solution I provided earlier.
Hope this helps.
Good luck.
Tony

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1