+ Reply to Thread
Results 1 to 7 of 7

Not able to correctly declare functions' arguments

Hybrid View

  1. #1
    Registered User
    Join Date
    06-28-2016
    Location
    Zurich
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Not able to correctly declare functions' arguments

    Quote Originally Posted by MrShorty View Post
    I believe that this is controlled in Windows Control Panel->Language and Regional settings -> List separator. Usually this is set to either , or ; Someone may have changed it to some other character. Assuming you are using Windows, check this setting and see what character is set as your systems list separator.
    I checked both the system and Excel separator. System wise I have comma as a separator of decimal numbers, while in excel I'm using the dot. None of these seem to work.
    I need to keep the two settings different because of some .txt files that I need to read with Excel that use the dot as a separator.

    Quote Originally Posted by xlnitwit View Post
    Hi,

    Looking at the prompts you are getting it appears you use the space as a separator so it would be:
    =SOMMA(33 99)
    Unfortunately, this is not the case. Using space as a separator prompts the very same error.
    Attached Images Attached Images
    Last edited by gmdv; 06-28-2016 at 11:51 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA functions & Arguments
    By Brad1951 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-04-2012, 07:24 PM
  2. Why do functions not allow commas to seperate arguments
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-06-2005, 08:05 PM
  3. Why do functions not allow commas to seperate arguments
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 05:05 PM
  4. [SOLVED] Why do functions not allow commas to seperate arguments
    By JohanS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  5. [SOLVED] Why do functions not allow commas to seperate arguments
    By JohanS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  6. [SOLVED] Why do functions not allow commas to seperate arguments
    By JohanS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. Custom functions using arguments with same name
    By Spencer Hutton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2005, 02:05 PM
  8. Using methods in functions with arguments.
    By BartDesc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1