Forum Discussion
Accounting Number Format Currency settings
I often work in another currency than the standard US$, British pound, Euros, Swiss Franc. In other words every time I need to format cells I need to perform 4 steps to get to i.e. Russian Rubles. ...
Have noticed that this function only works in that particular Excel file. If I open a new file I need to set it up again. How can I make it a default?
You could create a blank workbook with the new style and save it as the default template for new workbooks. See How to set a default template in Excel
This will work for new workbooks that you create by pressing Ctrl+N or by clicking New on the Quick Access Toolbar. It won't work for existing workbooks that don't have the custom style.