Add Dollar Sign in Google Sheets

Walter Jul 15, 2026

Need to display dollar amounts in Google Sheets but feeling stuck on how to insert a dollar sign? You're not alone. Google Sheets, much like its peers, has a slight learning curve when it comes to using currency symbols. But don't worry, we're here to simplify the process. By the end of this guide, you'll be inserting dollar signs like a pro.

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

Before we dive in, ensure you're using the latest version of Google Sheets. You can check this by navigating to 'Help' in the menu bar and clicking on 'About Google Sheets'. If you're not updated, follow the prompts to ensure your software is current.

WOULD YOU DO HTESE THING FOR A MILLLLLLYYYY
WOULD YOU DO HTESE THING FOR A MILLLLLLYYYY

Formatting Cells for Currency

Google Sheets simplifies adding a dollar sign by offering a built-in currency format. Here's how to use it:

Life Skills - Money Dollar Up - Pixel Art - Google Sheets - Spring
Life Skills - Money Dollar Up - Pixel Art - Google Sheets - Spring

1. Select the cells where you want to add the dollar sign. You can select a single cell or multiple cells at once.

Using the Number Format Option

Life Skills - Money Dollar Up - Pixel Art - Google Sheets - Back to School
Life Skills - Money Dollar Up - Pixel Art - Google Sheets - Back to School

Google Sheets allows you to change the number format directly in the header. Here's how:

a. In the menu bar, click 'Format' and then 'Number'.

b. Scroll down to the 'Currency' category and select the format that best suits your needs (e.g., $#,##0.00).

Life Skills - Money Dollar Up - Pixel Art - Google Sheets - St. Patrick's Day
Life Skills - Money Dollar Up - Pixel Art - Google Sheets - St. Patrick's Day

c. The dollar sign should now appear in your cells. If it hasn't, try pressing Enter or click outside the cell to apply the formatting.

Using the Format as Currency Option

Google Sheets also offers a 'Format as currency' option. Here's how to use it:

the google sheets has hidden gems you're not using on your webpages
the google sheets has hidden gems you're not using on your webpages

a. Select the cells where you want to add the dollar sign.

b. Right-click on the selected cells and choose 'Format as currency' from the context menu.

Create a Google Dashboard for Administrators using Google Sheets - Stephanie McConnell/Principal Principles
Create a Google Dashboard for Administrators using Google Sheets - Stephanie McConnell/Principal Principles
How to change the date format in Google Sheets!
How to change the date format in Google Sheets!
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
Life Skills - Money - Dollar Up - Mystery Pixel Art - Google Sheets - ATM
Life Skills - Money - Dollar Up - Mystery Pixel Art - Google Sheets - ATM
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
Weekly Planner (Google Sheets)
Weekly Planner (Google Sheets)
Life Skills - Money Dollar Up - Pixel Art - Google Sheets - Easter
Life Skills - Money Dollar Up - Pixel Art - Google Sheets - Easter
Add a Dynamic Mini Calendar in Google Sheets – Easy & Beginner-Friendly
Add a Dynamic Mini Calendar in Google Sheets – Easy & Beginner-Friendly
How to Calculate Running Total in Google Sheets
How to Calculate Running Total in Google Sheets

c. A dialog box will appear. You can choose the number of decimals you want to display, the currency, and the direction of the currency (left or right-aligned). Click 'OK' to apply the formatting.

Entering the Dollar Sign Manually

Sometimes, you might want to add the dollar sign manually, especially when dealing with very specific formatting. Here's how:

Using the CONCATENATE Function

The CONCATENATE function in Google Sheets can help join the dollar sign with your numerical data. Here's an example:

1. In a blank cell, enter this formula: =CONCATENATE("$",A1).

2. Replace 'A1' with the reference of your data cell.

3. Press Enter. The result should be your dollar amount prefixed with a dollar sign.

Using the TEXT Function

The TEXT function in Google Sheets can also help add the dollar sign. Here's how:

1. In a blank cell, enter this formula: =TEXT(A1,"$#,##0.00").

2. Replace 'A1' with the reference of your data cell.

3. Press Enter. The result should be your dollar amount in the desired format.

Google Sheets provides various ways to insert a dollar sign. Choose the method that best suits your needs and boost your productivity today!