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. This will not change existing files' currency settings. This way the default for the currency formatting button will go to the Euro automatically. 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. 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. 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.Įxcel uses your system settings to determine what the currency button does by default, but it doesn't actually have a default currency.
0 Comments
Leave a Reply. |