Excel equation setting - replacing ";" with ","

[lawrencema2468]

Hi guys,

Currently in my excel, whenever i put through an equation, the excel indicate that i need to use ";" to separate the items within the equation. ie. =sum(number 1;number 2....). Now the thing is that it really annoys me as i usually use "," to separate the items. How can i change it?

Appreciate!

[#2]

@lawrencema2468 

That depends on which list separator is being used as per your regional settings.

To change the list separator from a Semicolon to Comma, go to the Control Panel and open Region settings and in there click on Additional Settings and change the list separator as per your requirement.

Please refer to the image below...