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

     

     

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 04, 2024

      salighie 

      This icon

      doesn't mean USD, it means Accounting Number Format. In other versions of Excel it looks less confusing

      Clicking on it you set your default currency format (Euro, whatever). To apply specific currency format you shall to select it from drop-down menu.

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

        SergeiBaklan 

        Thanks for the reply.

        I probably should've mentioned that I'm an IT Professional. I've used Excel/MSO products in advanced ways for over 20 years, I'm well acquainted with _WHAT_ that button should do.

         

        And what it _HAS_ done for years, on the same laptop i've been using, is change the number format to USD from Number. Now it no longer does that on two workbooks.

         

        I think i've explained the two issues i'm seeing to the best of my ability, but again....

         

        On two long-existing workbooks, where that [$] button had been working correctly for years, that [$] button no longer works as expected. Something is broken and it's not a PEBKAC or a PICNIC or the ID-10T virus. ... at least i hope. LOL.

         

        thanks

Resources