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?
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.