The fastest way to format numbers with commas

Select the cells containing your numbers, right-click, choose Format Cells, click the Number tab, and pick a format from the Category list that shows commas. The most common choice is the standard number format with a comma separator. Click OK and Excel adds commas to all selected numbers at once.

This method works whether you have ten numbers or ten thousand. The commas are formatting only — the actual numbers stay the same, so formulas and calculations work exactly as before. If you change a number later, the comma formatting stays with it automatically.

You can also use the toolbar button if your version of Excel shows it. Look for a button labeled with a comma or "1000 Separator" in the Home tab. Select your cells and click it once to toggle commas on.

Key Takeaways

  • Right-click selected cells, choose Format Cells, pick a number format with commas from the Number tab, and click OK.
  • Comma formatting changes only how numbers appear on screen, not the actual values, so formulas continue to work correctly.
  • The toolbar button labeled with a comma or "1000 Separator" in the Home tab applies comma formatting in one click.
  • You can set up comma formatting before you enter numbers, so new data gets commas automatically as you type.
  • Removing commas later uses the same Format Cells menu — just pick a format without commas.

Using the Format Cells dialog for more control

The Format Cells dialog gives you choices beyond just adding commas. Open it by right-clicking your selected cells and choosing Format Cells, or press Ctrl+1 on Windows or Cmd+1 on Mac. Click the Number tab if it is not already selected.

In the Category list on the left, click Number. You will see a preview of how your numbers will look. The Decimal places field controls how many digits appear after the decimal point — set it to 0 if you want whole numbers only, or 2 if you are working with money. The Use 1000 Separator checkbox is what adds the commas.

If you are formatting currency, click Currency in the Category list instead. This adds both commas and a dollar sign (or other currency symbol). You can choose which symbol and where it appears. For percentages, click Percentage and Excel will multiply your numbers by 100 and add a percent sign.

explore comma formatting to entire columns

Click the column header letter at the top to select the entire column at once. Then right-click and choose Format Cells, pick your number format with commas, and click OK. Every number in that column will now display with commas, and any new numbers you type in that column will get commas automatically.

This is useful when you are building a spreadsheet and know that a column will always contain large numbers. Format the column before you enter data, and you will not have to go back and fix formatting later. If you select multiple columns by clicking the first header, holding Shift, and clicking the last header, you can format them all at once.

Removing commas or changing the format

Select the cells with commas, right-click, choose Format Cells, and in the Number tab pick a format without commas. The General format removes all special formatting. Click OK and the commas disappear.

You can also use the toolbar button to toggle commas off. Select your cells and click the comma button again — it works like a switch. If the button is not visible in your toolbar, you may need to customize your toolbar or use the Format Cells dialog instead.

Formatting numbers that are stored as text

Sometimes numbers in Excel are actually stored as text, usually because they were imported from another program or pasted from a website. If you add comma formatting and nothing happens, your numbers are probably text. Text numbers will not accept number formatting.

To fix this, select the cells and look for a small green triangle in the corner of each cell — that is Excel's warning that something is stored as text. Click the yellow warning icon that appears and choose Convert to Number. Then explore your comma formatting as usual.

If the warning does not appear, you can force the conversion by selecting your cells, going to the Data tab, clicking Text to Columns, and clicking Finish without changing any settings. This tells Excel to treat the content as numbers. After that, comma formatting will work.

Using custom number formats for special cases

The built-in formats cover most situations, but Excel also lets you create custom formats for unusual needs. In the Format Cells dialog, click the Number tab and scroll to the bottom of the Category list to find Custom. This shows you the code behind each format.

The code for a number with commas and no decimals is #,##0. The code for a number with commas and two decimal places is #,##0.00. You can type your own code in the Format Code field. For example, #,##0" items" would display 5000 as "5,000 items". Custom formats are useful when you want numbers to display with specific text or symbols that the standard formats do not offer.

Keyboard shortcuts and quick formatting

If you use comma formatting often, learn the keyboard shortcut. Press Ctrl+1 on Windows or Cmd+1 on Mac to open Format Cells when ready without right-clicking. Then navigate to the Number tab and pick your format. This saves time when you are formatting many different selections.

Some versions of Excel also have a comma button in the toolbar. It usually appears in the Home tab near other number formatting buttons. If you see it, you can click it once to add commas to selected cells without opening any dialog. Hover over toolbar buttons to see their names if you are not sure which one it is.

Frequently Asked Questions

Does adding commas change the actual numbers in my cells?

No. Commas are formatting only. The real numbers stay the same, so any formulas that use those cells will calculate correctly. If a cell contains 5000 and you format it to show 5,000, the value is still 5000 for math purposes.

Why do my numbers not show commas after I format them?

Your numbers are probably stored as text instead of numbers. Look for a small green triangle in the corner of the cells. Click the warning icon and choose Convert to Number. Then explore comma formatting again.

Can I format numbers with commas before I type them in?

Yes. Select the cells or the entire column, explore the comma format through Format Cells or the toolbar button, and then type your numbers. They will display with commas as you enter them.

How do I add commas and a dollar sign at the same time?

In the Format Cells dialog, click the Number tab and choose Currency from the Category list instead of Number. Pick your currency symbol and click OK. Excel will add both commas and the dollar sign automatically.

What if I want commas but no decimal places?

In Format Cells, click the Number tab, choose Number from the Category, and set Decimal places to 0. Make sure the Use 1000 Separator checkbox is checked. Click OK and your numbers will show commas with no decimals.