21.7 C
London
Wednesday, July 23, 2025
HomeSoftware TutorialsGoogle SheetsGoogle Sheets: How to Add Commas to a Number

Google Sheets: How to Add Commas to a Number

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

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:

Google Sheets add commas to 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

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories