Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-847334%22%20slang%3D%22en-US%22%3EExcel%20equation%20setting%20-%20replacing%20%22%3B%22%20with%20%22%2C%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847334%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20in%20my%20excel%2C%20whenever%20i%20put%20through%20an%20equation%2C%20the%20excel%20indicate%20that%20i%20need%20to%20use%20%22%3B%22%20to%20separate%20the%20items%20within%20the%20equation.%20ie.%20%3Dsum(number%201%3Bnumber%202....).%20Now%20the%20thing%20is%20that%20it%20really%20annoys%20me%20as%20i%20usually%20use%20%22%2C%22%20to%20separate%20the%20items.%20How%20can%20i%20change%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847367%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20equation%20setting%20-%20replacing%20%22%3B%22%20with%20%22%2C%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847367%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406750%22%20target%3D%22_blank%22%3E%40lawrencema2468%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20depends%20on%20which%20list%20separator%20is%20being%20used%20as%20per%20your%20regional%20settings.%3C%2FP%3E%3CP%3ETo%20change%20the%20list%20separator%20from%20a%20Semicolon%20to%20Comma%2C%20go%20to%20the%20Control%20Panel%20and%20open%20Region%20settings%20and%20in%20there%20click%20on%20Additional%20Settings%20and%20change%20the%20list%20separator%20as%20per%20your%20requirement.%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20image%20below...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20945px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131002iA846FEBD9514A76F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22List%20Separator.jpg%22%20title%3D%22List%20Separator.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
lawrencema2468
Occasional Visitor

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!

1 Reply

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

 

List Separator.jpg

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies