SOLVED

Excel 2020 configuration

%3CLINGO-SUB%20id%3D%22lingo-sub-2856981%22%20slang%3D%22en-US%22%3EExcel%202020%20configuration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2856981%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22%22%3Emy%20excel%20changed%20the%20%22%20%3B%20%22%20as%20the%20information%20divider%20inside%20a%20formula%20to%20%22%2C%22%20.%20How%20can%20I%20change%20it%20back%20to%20%22%20%3B%20%22%20%5B%20Example%3A%20From%26nbsp%3B%3DIF(logical_test%3CSTRONG%3E%2C%3C%2FSTRONG%3ETrue_Value%3CSTRONG%3E%2C%3C%2FSTRONG%3EFalse_Value)%20to%20%3DIF(logical_test%3CSTRONG%3E%3B%3C%2FSTRONG%3ETrue_Value%3CSTRONG%3E%3B%3C%2FSTRONG%3EFalse_Value)%20%5D%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2856981%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%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-2857041%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202020%20configuration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2857041%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1188698%22%20target%3D%22_blank%22%3E%40JVitor1180%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20two%20settings%20that%20influence%20this%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EThe%20regional%20settings%20in%20Windows.%20The%20list%20separator%20is%20the%20item%20you%20need%20to%20inspect.%3C%2FLI%3E%0A%3CLI%3EIn%20Excel%2C%20select%20File%20%26gt%3B%20Options%20%26gt%3B%20Advanced.%20In%20the%20'Editing%20options'%20section%2C%20inspect%20'Use%20system%20separators'.%20If%20this%20is%20off%2C%20Excel%20uses%20the%20Windows%20settings.%20If%20it%20is%20on%2C%20Excel%20uses%20the%20setting%20in%20the%20boxes%20below.%20If%20the%20decimal%20separator%20is%20a%20comma%2C%20formulas%20will%20use%20semicolon%20%3B%20to%20separate%20arguments%2C%20and%20if%20the%20decimal%20separator%20is%20a%20semicolon%2C%20formulas%20will%20use%20comma%20to%20separate%20arguments.%3C%2FLI%3E%0A%3C%2FOL%3E%3C%2FLINGO-BODY%3E
New Contributor

my excel changed the " ; " as the information divider inside a formula to "," . How can I change it back to " ; " [ Example: From =IF(logical_test,True_Value,False_Value) to =IF(logical_test;True_Value;False_Value) ]

2 Replies
best response confirmed by JVitor1180 (New Contributor)
Solution

@JVitor1180 

There are two settings that influence this:

  1. The regional settings in Windows. The list separator is the item you need to inspect.
  2. In Excel, select File > Options > Advanced. In the 'Editing options' section, inspect 'Use system separators'. If this is off, Excel uses the Windows settings. If it is on, Excel uses the setting in the boxes below. If the decimal separator is a comma, formulas will use semicolon ; to separate arguments, and if the decimal separator is a semicolon, formulas will use comma to separate arguments.
thank you, i managed to solve by disabling the second option