How to Add Dollar Signs in Excel

If you’re working with financial data in Excel, you’ll want to know how to add dollar signs to your numbers. This helps make your spreadsheets clear and professional. Thankfully, Excel makes it pretty straightforward to format cells with dollar signs. Here’s a quick guide to get you started.

How to Add Dollar Signs in Excel

In this section, you’ll learn how to add dollar signs to your numbers in Excel. This formatting makes your financial data easier to read and understand. We’ll go through the steps to show you how to format cells so that they display numbers as currency.

Step 1: Select the Cells

First, highlight the cells you want to format with dollar signs.

You can click and drag your mouse over the cells, or use the Shift and arrow keys to select a group of cells. If you want to select the entire column or row, simply click on the column or row header.

Step 2: Open the Format Cells Dialog Box

Right-click on the selected cells, and choose “Format Cells” from the context menu.

This action opens a new window where you can customize how your numbers appear. You can also access this by clicking on the small arrow in the bottom-right corner of the “Number” group on the Home tab.

Step 3: Select ‘Currency’ from the Category List

In the Format Cells dialog box, click on the “Number” tab, then choose “Currency” from the list on the left.

Here, you’ll see different options for formatting numbers, but for adding dollar signs, you want "Currency." This option automatically adds a dollar sign to your numbers.

Step 4: Choose Decimal Places and Symbol

Set the number of decimal places and make sure the dollar sign is selected as the symbol.

You can usually leave this at the default of two decimal places, but you can adjust it depending on your needs. Make sure the dollar sign is selected in the Symbol dropdown menu.

Step 5: Click OK

Click the “OK” button to apply the formatting to your selected cells.

After clicking “OK,” your numbers will now appear with dollar signs in front of them. It’s that simple! If you want thousands separators without a currency symbol, apply the Comma Style number format instead.

After completing these steps, your selected cells will now display numbers with dollar signs, making it clear that the values are in U.S. dollars.

Faster Ways to Add the Dollar Sign Format

• Keyboard shortcut: select the cells and press Ctrl + Shift + 4 (Ctrl + Shift + $). This applies the Currency format with two decimal places.
• Ribbon button: select the cells and click the $ (Accounting Number Format) button in Home > Number. Use its drop-down arrow to pick other currencies such as € or £.
• Number Format box: choose Currency or Accounting from the drop-down list in the Number group.
• Type it: entering $25 in an empty cell makes Excel apply Currency format automatically.

Currency vs. Accounting Format

• Currency puts the $ right next to the number ($1,250.00) and lets you choose how negative numbers appear, such as red or in parentheses.
• Accounting lines up the $ signs at the left edge of the cell and the decimal points in a column, shows zeros as a dash, and puts negatives in parentheses. It is the standard look for financial statements.

Custom Dollar Formats

In Format Cells > Number > Custom, you can type your own format:

• $#,##0 shows whole dollars, such as $1,250.
• $#,##0.00;[Red]-$#,##0.00 shows negatives in red.
• $#,##0.0,,"M" shows millions, such as $1.3M for 1,250,000.

Add a Dollar Sign Inside Text

Number formats do not carry over when you join a number into text. Use the TEXT function instead: ="Total: "&TEXT(B2,"$#,##0.00") returns “Total: $1,250.00.” See how to concatenate in Excel.

Dollar Signs in Formulas (Absolute References)

A $ inside a cell reference has a different job: it locks the reference when you copy the formula. $A$1 locks both the column and row, $A1 locks only the column, and A$1 locks only the row. To add them quickly, click the reference in the formula bar and press F4 to cycle through the options; on a Mac, press Command + T. For example, =B2*$E$1 multiplies each row by the rate in E1. On a Mac, see how to make an absolute reference in Excel on Mac.

Troubleshooting

The dollar sign does not appear

The cell contains text that looks like a number. Convert it with Data > Text to Columns > Finish or the error-check menu’s Convert to Number, then apply the format.

The cell shows ####

The formatted value is wider than the column. Double-click the right edge of the column header to widen it.

The wrong currency symbol appears

Currency defaults follow your Windows region. Choose the symbol you want in Format Cells, or change your region under Settings > Time & language > Language & region.

Tips for Adding Dollar Signs in Excel

• Use Keyboard Shortcuts: You can quickly add dollar signs by selecting your cells and pressing Ctrl+Shift+$.
• Conditional Formatting: For more advanced users, conditional formatting can automatically add dollar signs based on certain conditions.
• Custom Number Formats: You can create a custom number format if you need more specific formatting.
• Apply to Entire Sheet: You can format an entire sheet by clicking the box at the intersection of the row and column headers.
• Check for Consistency: Make sure all your financial data is formatted the same way to avoid confusion.

Frequently Asked Questions

What if I need to format multiple sheets?

You can select multiple sheets by holding down the Ctrl key and clicking each sheet tab before formatting.

Can I apply dollar signs to a whole column?

Yes, click the column header to select the entire column, then follow the steps to format cells.

How do I remove dollar signs?

To remove dollar signs, select the cells and choose “General” from the Format Cells dialog box.

What if I want a different currency symbol?

In the Format Cells dialog box, you can choose other currency symbols from the Symbol dropdown menu.

Does Excel automatically update the format if I change the value?

Yes, any new value you enter in a formatted cell will automatically display with a dollar sign.

Related: convert numbers to words in Excel.