Forum Discussion

lawrencema2468's avatar
lawrencema2468
Copper Contributor
Sep 10, 2019

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 thing is that it really annoys me as i usually use "," to separate the items. How can i change it?

 

Appreciate!

excel
Formulas and Functions
office 365

1 Reply

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Sep 10, 2019

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