Formatting numbers to have the comma

P

psaulm119

Board Regular
Joined
Apr 6, 2007
Messages
67
Is there a way to get Excel to insert the comma every third digit, in a number? For example, I have this number:


6903434000.00


Now I don't need the two digits to the right of the decimal, but is there a way to format the cells so that it automatically becomes 6,903,434,000 (with or without the decimals)?
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Got it. Select the cells you want to have this formatting for, right-click and select the Format Cells option, select the Number tab in the new dialog, then on the left side, click on Number. Make sure that the option to use the thousands separator is checked, and OK out. I would have googled this earlier but I had forgotten that this comma is called the "thousands separator."
 
Upvote 0
sure just right click on the cell, press format cells, on the number tab in the catagory list select Number and tick the box marked Use 1000 separator.

(take the decimal places down to 0 if you don't want them)
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Converting commas to full stops.
2
Replies
11
Views
664
arthurbr
arthurbr
M
  • Question
Excel Chart - number formatting as decimal only if decimal values are available in source data
Replies
0
Views
541
manekankit
M
M
  • Solved
Help with Excel number format - cell formatting
Replies
2
Views
294
Joe4
Joe4
A
  • Question
Datavalidation of social security numbers
Replies
2
Views
470
ausswe
A
T
  • Solved
macro for formatting numbers stored as text
Replies
3
Views
789
Joe4
Joe4

Forum statistics

Threads
1,214,788
Messages
6,121,600
Members
449,038
Latest member
Arbind kumar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top