Nov 20 2020 11:23 AM
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
Nov 20 2020 12:00 PM
Emile, if you are on Windows
Win+R
control international
Enter
Additional settings
Currency
and here change as desired
Nov 20 2020 03:35 PM
Apr 29 2022 04:01 AM
Apr 30 2022 04:30 AM
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?