You’ve got a new computer or had a reboot and suddenly Excel formulas need a semicolon instead of a comma? It won’t affect Excel, but it can be hard to get used to. There is an easy fix, but it is not in Excel but rather in your regional settings in Windows.
YouTube Excel formula semi-colon or comma separator
Steps to follow to make the change back from semicolons to commas
- In Windows look for your region and language settings in the control panel.
- Click on the Additional date, time & regional settings
- Choose to change date, time or number formats
- Click on Additional Settings at the bottom
- Change the List Separator to a comma by typing it.
All your formulas in Excel will now work with commas and you don’t have to worry about any of them. If they were semi colons they will change by themselves.
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.