Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two Mac OS X machines, both running Microsoft EXCEL 2011.

One uses a comma to separate function parameters, e.g:

function(arg1, arg2)

Yet my work machine uses semi-colons, e.g:

function(arg1; arg2)

How and where can I change this?

share|improve this question
Try this: – Paul Oct 31 '12 at 0:17
@Paul. Changing the 'dot' and 'comma' for decimals and thousands didn't do anything. However, changing the region to US, and then customizing everything back to European, did work. It is beyond me... – Maurits Oct 31 '12 at 19:36
Awesome. Well, you should answer your own question and mark it "answered," so other people can benefit from that if you don't mind! – Paul Nov 1 '12 at 13:58
up vote 1 down vote accepted

The Excel 2011 function argument delimiter seems to be tied in to the region settings of OS X. I have been able to get a comma as argument delimiter in Excel by setting the region of the machine to the US or to the Netherlands. (It was originally Swiss-French)

This obviously also changes the usage of the komma and the dot in number notations and the convention for showing dates. These I was able to customize all back to my original preference via the customize buttons, whilst leaving the new argument delimiter behavior intact.

share|improve this answer

For Mac OS X 10, the Advanced... settings in Language&Region allow you to choose the Decimal separator in 2 places, for Numbers and Currency.

If comma is not set in any of the Decimal separators, then it is free to be used as the "list separator" in Excel. Please note the whole Excel app needs to be quit&restarted for the change to take effect, not just closing&reopening a file.

The list separator applies to formulas as well as for opening CSV files.


share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .