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
excel
dddddddddddd's avatar
dddddddddddd
Copper Contributor
Apr 29, 2022
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
Diamond Contributor
Apr 30, 2022

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?

  • salighie's avatar
    salighie
    Copper Contributor
    Apr 30, 2024
    Have tried these steps. have clicked reset button, but excel still shows euros. the funny thing is that the values in the excel workbook had always been $$ never euros. now for some reason even the default number currency format butto [$] defaults to euro.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 01, 2024

      salighie 

      Are you on Windows?

      Let say I have $ as default currency in regional settings. Excel also shows $ by default.

      Now let change on Euro and click Apply. Nothing to do in Excel, it automatically shows the number in euro

      • salighie's avatar
        salighie
        Copper Contributor
        May 03, 2024

        SergeiBaklan 

        Hi, 

         

        Yes, i'm on windows 10 22H2 bld19045.4291

         

        Excel / MSO v16.0.5443.1000

         

        I have a couple of issues, seemingly related, but slightly different with two workbooks (i'll restate my exact problems below). However, if I create a brand new workbook there is no issue - the problems go away.

         

        NOTE: My System Currency and Locale info are set to US/USD as in the image attached.

         

         

        Problem 1: On one workbook (in the screenshot attached), the default Currency Symbol for the [$] currency format tool button seems to be stuck on Euros. I can click on the drop down (as shown above) and select $ English [...] currency and it will format the numbers correctly to USD but if I simply click on the [$] button it changes them back to Euros. 

         

        Problem 2: On another workbook, the same [$] button seems to be stuck on  "Number" format, ie just a Number. That is, the same behavior as in problem #1 applies, i can format as USD via the drop down selection, however if i click on the [$] button itself, all values are formatted back to Number. 

         

        These issues persist in their respective workbooks, including in New Sheets within the same workbooks, but as i mentioned already, these issues do not exist on a brand new workbooks.

         

        Should i just run a repair on office? 

         

         

         

Resources