How to Add Dollar Sign in Excel

- Written by Puneet

excelchamps-free-courses-puneet-gogia

In Excel, users add the $ dollar sign at the beginning of the value, representing the value as monetary value. you can also convert the standard numeric values into monetary values by adding the $ sign in front of them.

There are multiple ways to add the $ Dollar sign in Excel, like manually adding the $ sign in the cells or changing the cells’ format to currency or accounting format.

add-$-sign

This tutorial will show you how to add the $ Dollar sign in the cells in multiple ways.

Add the Dollar Sign by typing the $ Sign

  1. First, go to the cell and double-click in the cell or press “Fn +F2” keys to put the cell in edit mode.
  2. After that, move the cursor to the left side in front of the value and press the “Shift + $” keys together, and the $ sign will get added in front of the value.
    keyboard-keys-to-add-$-sign
  3. Once the $ sign got added into the cell, use the Format Painter to copy and paste the formatting into the rest of the cells to auto-add the $ sign into them.
    copy-paste-values

Add Dollar Sign using Concatenate Function

You can use the CONCATENATE function to add the $ sign with the values in the cell by following the below steps:

  1. First, go to the cell and write the “Concatenate” formula.
  2. In the formula, as shown in the below image, after the open parentheses, enter the dollar sign “$” and enter a comma, then select the cell reference (B2) where you have the value, and then close the parentheses and press enter.
    concatenate-to-add-$-sign
  3. After that, hover the mouse on the below right corner of the cell, and double-right-click to copy the formula to the rest of the cells.
    fill-handle-to-copy-format
  4. Copy the cells range with the formula and paste special to the cells where you want to have $ sign with values and then convert them to numeric values as shown below in the image.
    paste-special-and-convert-to-number-format

Add Dollar Sign using Text Function

You can also use the text function to add the $ sign in the cells by following the below steps:

  1. First, go to the blank cell and write the “TEXT” formula.
  2. In the formula, as shown in the below image, after the open parentheses, select the cell reference (B2) where you have the value with which you want to add the $ sign and enter a comma and then write the “$00” as format text value and close the parentheses and press enter.
    text-to-add-$-sign
  3. After that, hover the mouse on the below right corner of the cell, and double-right-click to copy the formula to the rest of the cells.
  4. Copy the cells range with the formula and paste special to the cells where you want to have $ sign with values and then convert them to numeric values as shown below in the image.
    paste-special-and-number-format

Add Dollar Sign by Converting the Cells Formatting to Currency or Accounting Format

  1. First, select the cells range and go to the “Home” tab.
  2. After that, click on the “Format” drop-down arrow under the “Number” group and choose the “Currency” or “Accounting” option from the menu.
  3. Once you choose any of the two formats, it will add a $ sign in the cells in the front of the values.
currency-and-accounting-formats

The only difference between the currency and accounting format is that in currency formatting, it places the $ sign at the beginning of the value. In accounting format, it places the $ sign in the extreme left or, you can say, at the beginning of the cell.

currency-vs-accounting-format

Shortcut to Apply Currency Format to Add Dollar Sign

You can convert the cell formatting to currency formatting using the keyboard shortcut to Currency Format:

Ctrl + Shift + $

Last Updated: April 21, 2024