The easiest way to add commas to a number in Google Sheets is to use the Number option within the Format tab.
The following step-by-step example shows how to use this option to add commas to a number in Google Sheets.
Step 1: Enter the Data
First, let’s enter the following dataset into Google Sheets that shows the total number of sales made by various employees at a company:
Step 2: Add Commas to Numbers
Next, highlight the cell range B2:B12:
Next, click the Format tab, then click Number, then click Number:
Commas will automatically be added to the values in the Sales column:
Note that within the Number tab, you can also specify that you’d like the values to be formatted as a currency with commas:
This will add a dollar sign in front of each value and force two decimal places to be shown for each value:
Notice that each value in the Sales column is now displayed in a currency format.
Additional Resources
The following tutorials explain how to perform other common operations in Google Sheets:
How to Use SUMIF Contains in Google Sheets
How to Use SUMIF with OR in Google Sheets
How to Sum Only Positive Numbers in Google Sheets