Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to use currency formatting in Excel

How to use currency formatting in Excel

Transcript 

In this lesson we'll take a look at the Currency format. The Currency format is designed to display a currency symbol along with numbers. It has options for the currency symbol itself, the number of decimal places, and negative number handling.

Let's take a look.

Let's start off by copying a set of numbers in General format across our table, and then apply the default currency format to the columns C through H.

Now let's select cells in column D and check the options available for currency in the Format Cells dialog box. Like Number format, the Currency format provides options for decimal places and handling negative numbers. However, it does not provide an option for a thousandths separator—this is always enabled for Currency.

Let's set decimal places to zero, and close the dialog. Like Number format, we can also adjust decimal places up and down using the buttons on the ribbon.

To display negative numbers in parentheses, we need to visit the Format Cells dialog box again.

With parentheses enabled, Excel shifts all numbers a bit to the left to keep numbers aligned on the decimal point.

We'll need to head to the Format Cells dialog box again to change the currency symbol to the British Pound. Excel provides a huge list of options for currency symbols, including abbreviations.

Note that there are shortcuts on the ribbon that include a currency symbol, but these actually apply the Accounting number format, which may not be desired.

You can use the Format Cells dialog to switch from Accounting back to Currency, leaving the Euro symbol intact.

One more visit to the Format Cells dialog to select the currency symbol of None.

Note that selecting None as the currency symbol has an interesting result: the format of the cells in column H is now no longer Currency, but is simply Number.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Just wanted to say your website is an amazing resource and I'm glad to have found it. Thank you for making it free.
Douglas
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page