Why does Excel expect commas or semicolons to separate the parameters in a formula? The answer can be found in this article.
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
How and where change this option?
Don't waste your time to find this option in Excel!
This option is not in Excel but in the local settings of Windows
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 of Windows 😉👍
Change your setting
When you select a country in the dropdown list, the default date and number settings are loaded.
For instance, if you select US, the date has the format mm/dd/yyyy and when you click on the button Additional settings, you can customize the decimal symbol (period or comma) but also the List separator.
The List separator is the option to write your formula with a comma separator or semi-colon separator.
And You don't have to Restart Excel to apply the settings. The change is immediate 😎😃👍
France, Spanish settings
If you don't mind, you can change the values of the country to load semi-colon as default list separator. It's the case for France or Spain. But in that case, your dates will be displayed in French or Spanish