Forum Discussion
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
Emile, if you are on Windows
Win+R
control international
Enter
Additional settings
Currency
and here change as desired
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!
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!
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?
- 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.
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
