Can I change the default currency symbol in Excel 2016 for a single workbook
I'm using Excel 2016 on MacOS High Sierra. I'm based in the UK, and so my global default currency symbol is £. I'm creating a new workbook with forecasts for a European operation, so in that workbook I want the default currency symbol to be €, so that I don't have to change all the cell formats manually. Is there any way to do this for just one workbook?
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.
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