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

@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
Average set of values if 2 criteria are met
jtorrens in Excel on
1 Replies
Refresh query to add new columns
Caesarus7 in Excel on
0 Replies
Frozen excel project
Mrkeats in Excel on
0 Replies
Macro to Import Data from PDF attachments (Outlook)
calof1 in Excel on
0 Replies
Text to Column (changing delimiters)
John11 in Excel on
0 Replies