• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Dollar Sign in Excel

April 22, 2021 by Andrew Childress
Dollar sign in Excel

Dollar signs are commonplace in spreadsheets. But you might be wondering how to work with them. Here's how to use dollar signs in Excel.

Dollar signs are commonplace in spreadsheets. But you might be wondering how best to work with them. Let’s learn how to use dollar signs in Microsoft Excel.

How to Use Dollar Signs in Excel

Spreadsheets often include many numbers. And in many applications, these will be U.S.-dollar values with a $ sign in front. Excel can handle the $ sign in many different ways.

By default, cells in Excel are formatted General. This is a flexible format that works well with almost any kind of data. Dollar signs, however, will automatically trigger Excel to reformat a given cell.

To demonstrate, click into an empty cell and type $100. Then, hit Enter on your keyboard. Watch the Cell Format dropdown on the Home tab on Excel’s ribbon. Notice, as you press Enter, that the cell format changes from General to Currency.

Dollar sign Excel

This impacts the behavior of the cells around the currency. For example, if you’ve placed the $100 figure in cell K1, click into cell K2 and type 30. (Notice, with a $ sign omitted).

Then, click into cell K3 and sum the two cells above:

=K1+K2

Excel will recognize the Currency format, and return the value $130 (with a $ sign) in cell K3.

Dollar sign in Excel

Excel offers a second option for displaying the $ sign. Click back into cell K1 to select it. Then, open the Cell Format dropdown. From it, choose Accounting.

You’ll notice the cell re-format. Accounting is meant specifically for dollar-and-cent applications. The $ sign will snap and lock on the left side of your cell. Your numerical value, no matter how large or small, will have two decimal places (.00) added to the end.

Dollar signs Excel

No matter what format you choose, Excel makes it easy to work with dollar signs. You can quickly perform monetary calculations in just a few clicks.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Dropdown list ExcelDrop-down List in Excel
Next Post:Make a Graph in Excelmake a graph in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top