Semi-colon vs Comma in Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know why Excel 2003 accepts only semi-colon as a separator
for arguments to a function and not comma as is indicated in the help. Is
this an option that can be changed?
 
Stuart said:
I would like to know why Excel 2003 accepts only semi-colon as a
separator for arguments to a function and not comma as is indicated
in the help. Is this an option that can be changed?
Click to expand...

Hi Stuart,

I think this depends on your location.

Try changing your locale to NZ or UK (I know they both use comma as
the separater).

HTH,

Alan.
 
I would like to know why Excel 2003 accepts only semi-colon as a separator
for arguments to a function and not comma as is indicated in the help. Is
this an option that can be changed?
Click to expand...

The separator depends on your regional settings.

In WinXP -- Control Panel/Regional and Language Options/Customize/Numbers and
change the List Separator to a comma.

This may have unwanted affects in other areas, though.


--ron
 
Back
Top