How to Add Commas to a Number in Google Sheets

Adding commas to a number in Google Sheets helps to make large numbers more readable by separating every three digits with a comma. This can be done using the Format options or by using the TEXT function.

Format options method

1. Open your Google Sheets document.
2. Select the cells containing the numbers that you want to add commas to. You can select multiple cells by clicking and dragging, or by holding the Ctrl (Cmd on Mac) key while clicking on individual cells.
3. Click on "Format" in the top menu.
4. Hover over "Number" to open the number formatting options.
5. Click on "1,000" or "1,000.00" depending on your preference. The former will add commas without decimals, while the latter will add commas and display two decimal places.

The selected cells will now display the numbers with commas.

TEXT function method

You can also use the TEXT function to format numbers with commas.

Example

1. In a new cell, type the following formula:

=TEXT(A1, "#,###")

Replace A1 with the cell reference containing the number you want to add commas to.

2. Press Enter.

The cell will now display the number with commas.

If you want to display decimal places, modify the formula as follows:

=TEXT(A1, "#,##0.00")

This will display the number with commas and two decimal places.