Most programming languages use comma separated arguments in their functions, like this: someFunction(arg1, arg2, ...) However, depending on your region and number format settings, Excel may choose to use semicolon instead. This is because Excel is trying to interpret comma as decimal separator, and so it decides to use semicolon for argument separator. This can be extremely frustrating for people who are used to programming languages having comma as argument separator in functions. In this tutorial, I'll show you how to change Excel to revert back to using comma as function argument separator. Note this tutorial is tested on Excel 2019 but may work with other versions as well. Excel Options Open the File menu and click on Options . (I hope you know where the File menu button is...) In the Excel Options interface, click on Advanced , then under the Editing options section, you should see 3 settings: Use system separators Decimal separat...
Blog about everything from funny memes to technology.