Forum Discussion
Excel not working properly with currency and formulas
I have the latest version of Excel on my 2021 macbook pro (16.70), first of all the currency is not set to $US dollars even if I downloaded Excel from microsoft website and I am located in the US, ad...
First, check your regional settings and make sure that the decimal separator is set to dot (point), and the list separator is set to comma. Here is what it looks like on my PC:
If the decimal separator and list separator are already set that way, check File > Options > Advanced.
Under Editing options, make sure that the check box 'Use system separators' is ticked.