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 semi-clone ";" .
FIND , MID 등 모든 함수의 수식에 들어가는 , 가 그냥 , 인식했을 땐 오류 메세지가 발생하며
이를 ; 으로 바꿔야만 정상 작동하고 있습니다.
A "," input in a formula such as =FIND(E3,2) or =MID(G2,1) appears as an error in my Excel.
And I have to replace it with ";" and enter it to work properly.
이를 기존 설정으로 돌릴려면 방법이 없을까요?
How do I change this to normal?
이를 기존 설정으로 돌릴려면 방법이 없을까요?
How do I change this to normal?
1 Reply
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.
