Why does Excel expect commas or semicolons to separate the parameters in a formula? The answer can be found in this article.
Table of Contents
Comma or semicolon ?
If you read this article, it's because one day you noticed that the separator between the parameters in any function is the comma sign or the semicolon.
Sometimes the separator is a comma
Sometimes the separator is a semicolon
Changing this is not an Excel option. It's a Windows parameter.
To switch between comma or semicolon as separator, follow the next steps
1. Open your Windows settings
2. Select the Time & Language menu
3. Then select Region & language > Additional date, time & regional settings
4. Click on Region > Change location
You can open the same dialog box with the command line intl.cpl in the search bar 😉👍
Change your setting
Now, you just have to select one country to change your setting. The parameter that can be changed is the List separator option
France, Spanish settings
You don't have to Restart Excel to apply the settings