Can I change the default currency symbol in Excel 2016 for a single workbook

Just highlight the entire page and change currency on the Home tab.

The best solution for Mac users: Quit from the Excel, go to System Preferences > Language & Region > Advanced > Currency (Also you could change the decimal sign from “,” to “.” or vice versa)

If you're using this a lot like me you can change your default currency.

Go to control panel
Region
Additional settings
Currency tab:change currency to your favorite one € (copy paste ) or leave it blank using space

For me personally, Peter's response was the better. Being located in the US, my system's Currency was set to the USD ($) but my excel default currency was the Euro (€). To change it I had to change the currency "Style".

1. On the Home tab, find the "Styles" group in the ribbon.
2. Find the "Currency" style.
3. Right click on it and select "Modify".
4. Click the "Format" button at the top.
5. Select the Currency symbol and format you want. If you can't find what you want, scroll down to "Custom" at the bottom and select your preferred formats or create your own.

I had a problem where a single workbook would always try to show Euro symbol whenever a number was inserted as currency format and would default to the euro symbol when manually formatting currency. The behaviour was particular to that workbook. Other workbooks would take the computers currency format (£).

I eventually figured out that in that one workbook the issue was with the "Style", the normal style was formatted as Euro, I could easily change it to £ as I wanted. So that would be one way you can format a single workbook to be in Euro.

Hope that helps anyone with that problem

Disclaimer: I do not have the Mac version of Office on which to test my suggestions, but all are central enough to Office that they should work virtually the same on both Mac and Windows platforms.

Excel uses your system settings to determine what the currency button does by default, but it doesn't actually have a default currency. In the number formatting group, rather than clicking the currency button (which will use your system default) you can click the drop-down arrow next to it to choose the Euro instead.

If you are doing this a lot and the extra step is inconvenient, you can always temporarily change your system currency settings then restart Excel. This way the default for the currency formatting button will go to the Euro automatically. This will not change existing files' currency settings.

If instead, you are trying to use an existing file which was created using the Pound and you want it to change all the currency fields to Euros, you can do a find and replace on the cell formatting. In the find and replace dialog box, clicking the Options button will allow you to select a format to search for. The easiest way to select the formatting is to use the Choose format from cell... option, but this may include additional formats besides just the currency.

Once the original format is selected, in the Replace with box, you can choose a new format and select a new currency of the Euro.

Completing the replace at this point should find all cells formatted with Pounds and replace them with Euro formatting. Be sure to change the Within: box in the Find and Replace window to Workbook if you have more than one sheet here that needs this change.