You may have wondered why suddenly Microsoft Excel is using semicolons (;) instead of commas (,) in separating your Excel formulas. I also experienced that and as a user that usually use commas in separating Excel formulas, this is quite annoying.
But fear not! We have a solution for that.
Now according to my research, this problem exists because of a certain language setting. Since I am a super lazy kid, I did not bother trying to find the exact solution over the internet. I tried to find it on my own using the single clue I got over the inter-webs, the “Language Settings”.
However, I won’t be giving you a hard time to solve this one so I’ll just give you the exact instructions (Yay!).
Just a note though. I am currently running Windows
The exact step by step instructions might be different in other Windows platform but in the end you’ll just have to tinker with your Language settings.
To cut the story short, you’ll have to change the setting List Separator in the Language Settings (seem pretty simple — and legit).
For those who want to have the step by step instructions, read on (ughh).
So you still want to continue this 99 pager post? (whaaat? asdfghjkl!). Nah. I’m just joking. Anyway, in addition to the step by step instructions, I prepared screenshots to keep you interested. Remember, this tutorial was done in Windows 10.
- In order to find the List Separator settings, head to your Start Menu and type Language.
- In the Language Control Panel, click Change date, time, or number formats.
- After clicking the Change date, time, or number formats link, a the new window will appear. Click Additional Options.
- After another a new Window appears (seriously, there are so many Windows going on!), go to the List Separator section and input comma (,) or any symbol that you want.
- Of course after changing the list separator, don’t forget to click Apply!
After applying the changes, you will immediately notice that Excel will now use comma (or any symbol that you inputted in the list separator) in your formula bars.
That’s it folks!
And that’s it! You’ve just learned how to fix you’re problems with semicolons or commas. Cheers!