In Excel, how do I change the argument separator in a function fr.

S

Springsteel

User has arguments within functions separated by semicolons rather than
commas. Would like to change to default to comma separation.

EX: =IF(A1>0;B1;C1) ---- Current argument separator
=IF(A1>0,B1,C1) ---- Prefered argument separator
 
D

Dave Peterson

This is a windows setting.

Windows start button|settings|control panel|regional settings applet
regional options tab (in winxp), click customize

Look for Numbers tab
List separator.

change from semicolon to comma.

Semicolon is very common in Europe and other non-North American locations.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
How do I default separator for thousands when working in XLS in t. 3
Excel Save As Options 2
SUMIFS help page online? 3
I need to do a calculation based on the values in two cells 2
=SUMPRODUCT((Data1!$B$1:$B$500="March")*(Data1!$C$1:$C$500="New 3
How to copy the function SUM but offseted in 7 columns 2
How to create a function 2

Top