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?

Don't use *Accounting* format............instead define a unique ***Style*** to match your needs. — Gary's Student, Dec 17 '15 at 14:59
@Gary'sStudent how unique ***Style*** is set in excel? P.Obertelli - I'm trying to avoid system level changes. — Zameer Ansari, Dec 17 '15 at 15:19

score 2 · Answer 1 · answered Dec 17 '15 at 16:01

2

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

answered Dec 17 '15 at 16:01

Gary's Student

just a confusion - does it changes the default currency format for Excel? – Zameer Ansari Dec 17 '15 at 16:41
@student You can apply the **Style** to a cell from the *Styles* menu – Gary's Student Dec 17 '15 at 17:03
I m not sure whether ***Style*** will solve my problem or not however this will be "new" learning for me. Thanks! – Zameer Ansari Dec 17 '15 at 17:06

1 Answers1