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?
Answered by Alan A on November 22, 2021
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)
Answered by Azamat on November 22, 2021
If you're using this a lot like me you can change your default currency.
Go to control panel
Currency tab:change currency to your favorite one € (copy paste ) or leave it blank using space
Answered by MOHAMED TAHER on November 22, 2021
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".
Answered by Mike on November 22, 2021
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
Answered by PETER W on November 22, 2021
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.
Answered by techturtle on November 22, 2021
1 Asked on August 8, 2020 by arjun
1 Asked on August 7, 2020 by adam-przedniczek
2 Asked on August 5, 2020 by mill
1 Asked on August 5, 2020 by kaleb
1 Asked on August 4, 2020 by techhorse
1 Asked on August 1, 2020 by finn-rup-nielsen
1 Asked on July 29, 2020 by igrimpe
2 Asked on July 27, 2020 by saadq
1 Asked on July 26, 2020 by cicekadam
4 Asked on July 26, 2020 by aarav-prasad
2 Asked on July 24, 2020 by marcusw
Get help from others!