Forum Discussion
emileaboumrad
Nov 20, 2020Copper Contributor
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
SergeiBaklan
MVP
Emile, if you are on Windows
Win+R
control international
Enter
Additional settings
Currency
and here change as desired
emileaboumrad
Nov 20, 2020Copper 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
- SergeiBaklanNov 21, 2020MVP
emileaboumrad , you are welcome