For example, in North America you would write ) and check what character is set as List Separator there.
And then, use exactly that character to separate arguments in your Excel formulas.
Remember that in Excel formulas, a comma is typically used to separate a function's arguments, and the dollar sign makes an absolute cell reference.
For instance, instead of entering $50,000 in your formula, input simply 50000, and use the ) to format the output to your liking.
The visual indicators of text-numbers are as follows: The below screenshot shows that even a simple Excel SUM formula may not work because of numbers formatted as text: To fix this, select all problematic cells, click the warning sign, and then click Convert to Number: In some cases, however, neither green triangles nor the warning sign appear in cells.