Forum Discussion

emileaboumrad's avatar
emileaboumrad
Copper Contributor
Nov 20, 2020

changing the default currency format

When I choose currency as the format of a cell, the default sign is EURO and 2 decimal points. How can i set the default to be the DOLLAR sign ($) and zero decimal points?

 

Thanks

Emile

    • emileaboumrad's avatar
      emileaboumrad
      Copper Contributor
      Sergei. Thank you very much for your post. It worked!! I thought Excel had its own defaults, and that is what I couldn't find. Didn't think of looking a Windows settings. Thanks again
    • dddddddddddd's avatar
      dddddddddddd
      Copper Contributor
      Hi Sergei,
      I was able to change this setting, but it still isn't applying to excel
      I restarted excel as well - is there anything else that I need to do ?

      Thank you!
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        dddddddddddd 

        Let me clarify your steps. Let assume you have Euro now as default currency.

        - you open new blank, type in empty cell 123 and apply Currency format. It shows

        - we open Windows settings, change Euro on $ and click Apply

        - go back to Excel (restart is not required, same Excel file). Now we see

        If you repeat as above does it work?

Resources