All geek questions in one place

How to change excel function separator ";" on ","?

In my Excel, I have to use if(a=b;1;0) .

But I want to use if(a=b,1,0) .

How can I change it?

My OS is Mac OS.

+4
source share
2 answers

Try changing your regional settings. I'm not sure how to do this on Mac OS. Check it out and change the list separator to ";" on ","

+2
source

It is tied to the OS language setting. If you change it at this level, it will also be changed in Excel.

0
source

Source: https://habr.com/ru/post/1493809/

More articles:


All Articles