Forum Discussion
lawrencema2468
Sep 10, 2019Copper Contributor
Excel equation setting - replacing ";" with ","
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 t...
Subodh_Tiwari_sktneer
Sep 10, 2019Silver Contributor
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...