Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to change the excel function separator ";" to ","? [closed]

Tags:

function

excel

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

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

How could I change it?

My OS is Mac OS.

like image 959
elixiao Avatar asked Jul 27 '13 12:07

elixiao


1 Answers

Try changing your regional settings. I am not sure how it is done in Mac OS. Check for it and change list separator from ";" to ","

like image 88
Kannan Suresh Avatar answered Oct 20 '22 19:10

Kannan Suresh