2

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

Default account format

  • 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?

Improve this question
3
  • 2
    Don't use Accounting format............instead define a unique Style to match your needs.
    – Gary's Student
    Commented Dec 17, 2015 at 14:59
  • 1
    did you try changing the regional language setting ?
    – P. O.
    Commented Dec 17, 2015 at 15:03
  • @Gary'sStudent how unique Style is set in excel? P.Obertelli - I'm trying to avoid system level changes.
    – Zameer Ansari
    Commented Dec 17, 2015 at 15:19

1 Answer 1

Reset to default
2

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

enter image description here

Improve this answer
3
  • just a confusion - does it changes the default currency format for Excel?
    – Zameer Ansari
    Commented Dec 17, 2015 at 16:41
  • @student You can apply the Style to a cell from the Styles menu
    – Gary's Student
    Commented Dec 17, 2015 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
    Commented Dec 17, 2015 at 17:06

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .