Home // Blog & Excel Tips // Excel formulas need a semicolon instead of a comma?

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

Excel formulas need a semicolon instead of a comma?

Comments Closed
Uncategorised

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.
Excel formulas need a semicolon instead of a comma

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.