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

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Format Currency in Excel

July 29, 2021 by Andrew Childress
Format currency in Excel

As you work in Microsoft Excel, you’ll find yourself manipulating many categories of data. Let’s learn how to format currency in Excel.

As you work in Microsoft Excel, you’ll find yourself manipulating many categories of data. One of these likely includes currency, especially if you’re working with financial data. Fortunately, Excel offers many great ways to format and work with currency values. Let’s learn how to format currency in Microsoft Excel.

How to Format Currency in Excel

Excel works with countless currencies, including dollars, Euros, and many more. This makes it easy for you to work with financial data from around the world.

By default, cells in Excel workbooks are set to General format. General is a multi-purpose cell format, but it falls short when you’re working with specific values like currencies.

For a basic example, find an empty cell in your workbook. Click into it, and type in a dollar value:

$50

Hit Enter on your keyboard. On the Format Cells dropdown on Excel’s Home tab, you’ll see that Excel automatically recognizes $50 as a currency, and reformats the cell to Currency format. This is a great start, but you still have plenty of options available.

Format currency in Excel

With the cell still selected, click on the Format Cells dropdown arrow. Then, choose More Number Formats. Excel will open the Format Cells menu, already set to the Currency category. Here, you have an array of choices available.

Currency format in Excel

For example, you can specify how many decimal places to show. You can also choose to shade negative values in red, or place them in parentheses. Plus, by using the Symbol dropdown, you can change dollars to a variety of other currencies with a single click.

When you’re finished making changes and edits, go ahead and click OK. Excel will apply the selected currency formatting to your data. This is a great way to make your data more useful by controlling exactly how currency values will display.

How to format currency in Excel

As you can see, it’s a breeze to format currency in Excel. Use these tips any time you’re working with financial data.

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

About Andrew Childress

Previous Post:Show bottom percents of your data in ExcelHow to Show the Bottom Percents Of Your Data in Excel
Next Post:How to Show the Top Percents Of Your Data in ExcelHow to show the top percents of your data 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