Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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...
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default 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...

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maxium hours that excel accept Marco Excel Discussion (Misc queries) 2 November 7th 07 11:55 AM
Getting rid of unusable charts? Bubba Excel Discussion (Misc queries) 1 May 4th 06 12:30 AM
Getting rid of unusable charts? Bubba Charts and Charting in Excel 1 May 4th 06 12:30 AM
Exporting to text, cells with comma's are placed in quotes. -Bad pallid Excel Discussion (Misc queries) 3 October 28th 05 04:41 PM
Why won't excel accept my password? excel password Excel Discussion (Misc queries) 2 March 15th 05 12:45 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"