Formatting numbers to have the comma

[psaulm119]

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)?

 

[psaulm119]

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."

 

[shadow12345]

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)