Forum Discussion
Error where "," is recognized as ";" in Excel formula
제 엑셀 프로그램에서 모든 함수에 들어가는 , 가 전부 ; 로 바꿔서 입력해야 정상 작동하는 오류가 발생하고 있습니다. In my Excel program, the , I am getting an error that the ", "in all functions is not recognized and I have to change it to a sem...
By default, Excel uses your regional settings: if you use a point as decimal separator (for example one-and-a-half is written as 1.5), you should use a comma between the arguments of a function:
=SUM(A1,A3)
But if you use a comma as decimal separator (one-and-a-half is written as 1,5), then you should use a semi-colon ; between the arguments of a function.
In Excel for Windows, you can specify the decimal separator in File > Options > Advanced to be different from the regional settings: clear the check box 'Use system separators' and enter the decimal separator and thousands separator you want to use.