Adding Dollar Signs to Google Sheets Sums: A Simple Guide

Walter Jul 15, 2026

When dealing with financial data in Google Sheets, it's important to present your sums in a clear and understandable manner. One way to do this is by adding the dollar sign to your sums. This not only makes your data more readable but also makes it easier to understand the units of measurement. Here's how you can do it:

How to Nest Multiple IF Statements in Google Sheets
How to Nest Multiple IF Statements in Google Sheets

Google Sheets automatically adjusts the format of your cell based on the content. However, it doesn't automatically add a dollar sign to your sums. To add a dollar sign, you'll need to format your cells manually. Let's dive into the steps:

How to Add and Sum in Google Sheets
How to Add and Sum in Google Sheets

Formatting a Single Cell

If you want to add a dollar sign to a single cell, follow these steps:

How to Create a Cumulative Sum Chart in Google Sheets
How to Create a Cumulative Sum Chart in Google Sheets

1. Select the cell you want to format.

2. Right-click on the cell and select 'Format' from the drop-down menu.

Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square
Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square

3. Choose 'Number' from the sub-menu that appears. This will open the 'Format number' pane on the right side of your screen.

Using the Custom Number Format Option

You can use the 'Custom Number Format' option to add a dollar sign to your sums. Here's how:

How To Make A Budget On Google Sheets in 2026 (+ Examples)
How To Make A Budget On Google Sheets in 2026 (+ Examples)

4. In the 'Format number' pane, under the 'Category' list, select 'Custom number format'.

5. In the 'Format' box, type '$#,##0' (without quotes) and press 'Enter'. This will apply the USD format to your sum.

Using the Currency Option

How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier

Google Sheets also provides a built-in 'Currency' option to add a dollar sign to your sums. Here's how:

6. Instead of 'Custom number format', select 'Currency' from the 'Category' list.

a laptop with google sheets on it and the words google sheets for teachers above it
a laptop with google sheets on it and the words google sheets for teachers above it
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
12 Free Aesthetic Google Sheets Budget Templates | Monthly Professional Finance Tracker
12 Free Aesthetic Google Sheets Budget Templates | Monthly Professional Finance Tracker
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
Struggling to add Alternating Colors in Google Sheets
Struggling to add Alternating Colors in Google Sheets
How to sum by category in Google sheets
How to sum by category in Google sheets
How to Add Error Bars in Google Sheets
How to Add Error Bars in Google Sheets
How to Add a Drop-Down List in Google Sheets and Excel - Make Tech Easier
How to Add a Drop-Down List in Google Sheets and Excel - Make Tech Easier
Google Sheets Checkbox Strikethrough
Google Sheets Checkbox Strikethrough

7. The 'Format number' pane will update to show various currency options. Select the 'USD' option, and your sum will now have a dollar sign.

Formatting a Range of Cells

If you want to add a dollar sign to a range of cells, instead of doing it one by one, you can use the 'Format as table' option. Here's how:

1. Select the range of cells you want to format.

2. Right-click on any of the selected cells and choose 'Format' from the drop-down menu.

3. This time, instead of going to 'Number', pick 'Format as table' from the sub-menu.

Using the Currency Column Type

You can use the 'Currency' column type to add a dollar sign to your sums. Here's how:

4. In the 'Format as table' pane, under the 'Create a table starting at' section, click on the icon that looks like aenserter next to 'Columns A:'. This will open the 'Create table' dialog box.

5. Click on 'Advanced', which is located at the bottom of the dialog box. This will open the 'Advanced' tab in the 'Create table' dialog box.

6. Under the 'Data type' list, choose 'Currency'. Your sums will now have a dollar sign.