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

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Currencies in Excel

August 15, 2021 by Andrew Childress
Currencies in Excel

Excel is capable of processing a wide variety of data, and is often used for financial data. Let’s learn how to display currencies in Microsoft Excel.

Excel is capable of processing a wide variety of data, and is often used for financial data. Here, it’s often useful to display numbers in currency values. Fortunately, Excel is well-equipped to handle currency data from around the world. Let’s learn how to display currencies in Microsoft Excel.

How to Display Currencies in Excel

Consider the number 500. Is it a numerical value? A sum? A price? If it’s a financial value, this makes 500 a currency. But until you have the appropriate currency symbol displayed with it, this won’t be very obvious to other users of your spreadsheets.

Currency formatting in Excel is ready to help you. Excel has a vast library of built-in currency information that you can easily apply to any numerical value inside your spreadsheets.

To get started, click into any empty cell in your workbook. Then, type in a number. We’ll use 500 in this example. Then, with the cell selected, find the Home tab on Excel’s ribbon. Near the middle, you’ll see the Cell Format dropdown menu. Go ahead and click on it.

Currency in Excel

You’ll see a list of options appear. One reads Currency. If – and only if – you’re working with U.S. dollars, you can simply click this, and your value will convert to $500.00. But if you want a different currency, click More Number Formats at the bottom of the dropdown.

On the Format Cells menu that appears, click Currency under the Category section. Here, in the Symbol dropdown, you can choose from a vast list of world currencies. Below, you can also choose how to display negative numbers, by placing them in parentheses or even shading them in red.

Currencies in Excel

When you’re finished, click OK. Excel will apply your settings to your number input.

Display currencies in Excel

As you can see, it’s easy to display, modify, and work with currencies right inside Microsoft Excel.

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

About Andrew Childress

Previous Post:Watch Window in Excel
Next Post:Subtotals in ExcelSubtotal at each change

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