Change the currency symbol in Excel 2016 for Mac

If you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab in the Number Format box.

On the Home tab, select Number Formats

Format numbers as currency

  1. Select the cells.

  2. On the Home tab, in the Number Format box, select Currency.

  3. On the Currency menu, select the currency symbol that you want.

    Currency menu on the Home tab

    Note: For information about how to type the euro sign (€) in a cell, see Keyboard shortcuts for the euro currency symbol.

Change the position of the currency symbol

There are two ways to change the position of the currency symbol:

  • The regional settings for currency determine the position of the currency symbol. The symbol can appear before or after the number, and there can be a space separating the symbol and the number. The regional settings also determine the decimal symbol and the thousands separator. You can control these settings by using the Mac OS X Language & Region system preferences.

  • If you want all the currency symbols to line up, select Accounting, rather than Currency in the Number Format box.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!