How to change default Accounting Number Format?

Question

In most cases, the default accounting format in Excel is $

• Without using some kind of macro

• Without changing timezone (or other system settings) of the computer

How to change this and set another currency as default using Excel's built-in settings?

Solution

To create a new Style just click on Cell Styles in the Home tab and then click on New cell style...

Comments

[Gary's Student]

Don't use Accounting format............instead define a unique Style to match your needs.

[P. O.]

did you try changing the regional language setting ?

[xameeramir]

@Gary'sStudent how unique Style is set in excel? P.Obertelli - I'm trying to avoid system level changes.

[xameeramir]

just a confusion - does it changes the default currency format for Excel?

[Gary's Student]

@student You can apply the Style to a cell from the Styles menu

[xameeramir]

I m not sure whether Style will solve my problem or not however this will be "new" learning for me. Thanks!