Excel do not accept any comma's (,) making them unusable... Help!
 

I can't use any excel function which contains a comma. This include IF,
VLOOKUP, ROUND, etc. None of these functions is accepted even if I use the
function screen with the veriable fields.

What is wrong and how do I correct it?

NOTE: This is not specific to a windows release or office suite. I had this
problem with Windows XP and Vista also with Office 2003 and 2007. It may have
something to do with a local template or file I backup and restore - but I
have not idea which file of template. Thus I have no idea to correct it...

Excel do not accept any comma's (,) making them unusable... Help!
 

Check your local/regional/international settings to insure that the comma is
an argument separator.
--
Gary''s Student - gsnu200761


"Gertjie Deysel 16404" wrote:

I can't use any excel function which contains a comma. This include IF,
VLOOKUP, ROUND, etc. None of these functions is accepted even if I use the
function screen with the veriable fields.

What is wrong and how do I correct it?

NOTE: This is not specific to a windows release or office suite. I had this
problem with Windows XP and Vista also with Office 2003 and 2007. It may have
something to do with a local template or file I backup and restore - but I
have not idea which file of template. Thus I have no idea to correct it...

Excel do not accept any comma's (,) making them unusable... Help!
 

Some countries use a semicolon (;) instead of a comma to separate the
parameters in a function - have you tried to enter a function using
semicolons?

Pete

On Dec 10, 9:58 am, Gertjie Deysel 16404 <Gertjie Deysel
wrote:
I can't use any excel function which contains a comma. This include IF,
VLOOKUP, ROUND, etc. None of these functions is accepted even if I use the
function screen with the veriable fields.

What is wrong and how do I correct it?

NOTE: This is not specific to a windows release or office suite. I had this
problem with Windows XP and Vista also with Office 2003 and 2007. It may have
something to do with a local template or file I backup and restore - but I
have not idea which file of template. Thus I have no idea to correct it...