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 to 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.
As you can see in the picture, the list separator is a comma. Also the date format is M/d/yyyy (month, day, year)
Now, when you write a formula, the separator between each arguments is a comma. And for the date as well, automatically your dates will be written with the US date format.
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